A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

CREATE PROC syntax in ADP



 
 
Thread Tools Display Modes
  #1  
Old December 4th, 2004, 01:09 AM
aaron kempf
external usenet poster
 
Posts: n/a
Default 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.

  #2  
Old December 4th, 2004, 06:02 AM
Larry Linson
external usenet poster
 
Posts: n/a
Default

"aaron kempf" wrote

just for the record:

http://groups.google.com/groups?q=aaron.kempf%

40gmail.com&hl=en&lr=&selm=Ou8g5md0EHA.1524%40TK2M SFTNGP09.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 see nothing in all 17 posts in that thread to indicate that (1) you were
censored or (2) that any Microsoft person posted to the thread at all. Could
you clarify just what in that thread indicates that Microsoft censored you?

.. . .

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.


"Deprecated", in Redmond-speak, means they are no longer recommending you
use that feature, that you do it another way. That other way could only be
MDB or DAP, since those are the only other two options in Access. It
_implies_, too, that they don't have plans to exert a great deal of effort
on that feature/function because they think you ought to do it another way.
So, I fear you are screaming your demands into a strong wind blowing the
other way from Redmond.

Perhaps the statement that they are deprecating ADP might be translated to
"we thought this was a good idea, and we implemented it, but it didn't
really turn out as well as we had hoped, so we aren't going to do any more
with it", but perhaps there are other equally probable translations, too. I
doubt Microsoft is likely to endorse my translation, though. G

....

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


Good luck. Oracle is a server database, like Microsoft SQL Server, not a
user interface tool. Oracle does make an application server and has an
"Oracle Forms" capability, but those are far too complex, and thus far too
expensive, for most individuals or even smaller organizations, and not
useful except with Oracle databases, if memory serves. Sybase's PowerBuilder
is a front-end creation tool, but your clients or your employer will have to
have support for it on their systems. It, too, would be significantly more
expensive than Access.

If you are looking for a next-generation development environment to interact
with Microsoft databases, you might want to look into Visual Studio.NET's
VB.NET, C#, and ASP.NET. Borland, among others, also plans to have some
..NET-compatible development tools. And, there are open-source projects to
address .NET development.

Larry Linson
Microsoft Access MVP





  #3  
Old December 5th, 2004, 04:01 AM
Larry Linson
external usenet poster
 
Posts: n/a
Default

"aaron kempf" wrote

just for the record:

http://groups.google.com/groups?q=aaron.kempf%

40gmail.com&hl=en&lr=&selm=Ou8g5md0EHA.1524%40TK2M SFTNGP09.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.


It appears that you added microsoft.public.access to the newsgroups in the
post to which I am responding, that it did appear in
microsoft.public.access -- and that is inconsistent with your being censored
or blocked. I see a number of other posts from you in this same newsgroup.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create User Selectable Filter for a Report Pete Sperling Setting Up & Running Reports 2 July 13th, 2004 06:49 PM
syntax to run PL/SQL stored proc via ms access pass through query Edwinah63 General Discussion 2 June 23rd, 2004 03:47 AM
When I try to open/save .rtf attachment I get the messages ?Can't create file. Right-click the folder you want to create item in and then click on the shortcut menu to check your permissions for the folder.? Nie Geweune via AdminLife Installation & Setup 0 April 27th, 2004 11:16 AM
Syntax of excel Tapani Tuominen Worksheet Functions 2 March 30th, 2004 09:12 PM
correl() function - create matrix?? Mark Worksheet Functions 4 March 27th, 2004 11:03 PM


All times are GMT +1. The time now is 03:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.