CREATE PROC syntax in ADP

just for the record:

http://groups.google.com/groups?q=aa...phx.gbl&rnum=3

this is the link, in microsoft.public.access where Microsoft censored
me. So don't you go about telling me who censors me and who doesn't.

I don't care how bad i ramble-- microsoft has major issues.. they have
buggy programs; and they're refusing to do anything about it.

Microsoft is a bully and someone needs to kick their ass in the open
marketplace-- teach them that they're not invincible.

They're too proud to fix problems in their products.

I just want some CLARIFICATION on what is happening with ADP;
Microsoft kept on telling me that it is being 'depecreated in Office
12' but they don't bother to tell me EXACTLY what that means.

I found MAJOR BUGS IN ADP-- RANDOM EXECUTE OF STORED PROCEDURES IS NOT
ACCEPTABLE. ADP RANDOMLY EXECUTES STORED PROCS!!!!

I've been bitching about it for a year.. And Microsoft can't fix thier
products..

So I am done; I am going to take some classes on Oracle or something

Aaron Kempf
OLAP Developer
ADP Nationalist






(aaron kempf) wrote in message . com...
Wow. I didn't think that there were that many idiots left in this
world.

1) I double-post in this newsgroup, because MICROSOFT CENSORS THEIR
NEWSGROUP.
I just learned this.

2) of course I know that ADPs don't store the sproc in the ADP file--
it is in the SQL Server database.

a). Create a sproc with query analyzer using the 'CREATE PROC SPHAPPY
AS SELECT * FROM SYSOBJECTS'

b). Open this sproc in ADP and in design view, change this to saw
"SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U'

c). Try to save your changes; and you will get an error 'the parameter
is incorrect'

I have told Microsoft about this 100 times; and I have to deal with
this bug 10 times per day.

It just ****es me off that Microsoft can't fix a serious problem in
their most profitable business line.

And what ****es me off more, is that you ACCESS MVP DON'T KNOW
_ANYTHING_ ABOUT ADP.

SCREW MDB. SCREW MVP's THAT DONT KNOW ENOUGH ABOUT ADP.








"Tom Travolta" wrote in message ...
"aaron kempf" wrote in message
om...
I find that ADP does not support any Stored Procedures that use the 'CREATE
PROC spHAPPY' syntax.

CREATE PROC syntax is listed in books online.
This syntax should be supported

Here is a scenario:

1) create proc using query analyzer and CREATE PROC spHAPPY syntax
2) open this proc in ADP
3) make changes to proc
4) try to save and you get the 'Parameter is incorrect' error.

can we PLEASE get someone to fix this; and stop giving excuses??


Not that we need to, but we are entitled to give as many excuses as we like.
How about this one:
"We do not owe free consultation to people who do not know the basics of
stored procedures and adp's."

and PLEASE don't multi-post.