ADP中的CREATE PROC语法 [英] CREATE PROC syntax in ADP
问题描述
我发现ADP不支持任何使用''CREATE
PROC spHAPPY''语法的存储过程。
CREATE PROC语法列出在线书籍。
应该支持这种语法
这是一个场景：
1）创建过程使用查询分析器和CREATE PROC spHAPPY语法
2）在ADP中打开此proc
3）对proc进行更改
4）尝试保存并且你得到''参数不正确''错误。
我们可以请别人来解决这个问题;并且停止给出借口??
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??
推荐答案
据我所知，ADP本身并没有存储过程。那是'b $ b不是借口，这是事实。 ADP是前端。到数据库，而不是
本身就是一个数据库。
你想在SQL Server数据库中创建一个存储过程
ADP用作数据存储区？你会用SQL的DDL SQL方言做到这一点，并且
如果你有适当的权限，它肯定是可能的。
Larry Linson
Microsoft Access MVP
" aaron kempf" < AA ********* @ gmail.com>在留言中写道
新闻：2f ************************** @ posting.google.c om ...
ADPs, as far as I know, do not themselves have "stored procedures". That''s
not an "excuse", it is a fact. An ADP is a "front-end" to a database, not
itself a database.
Do you want to create a Stored Procedure in the SQL Server database that the
ADP is using as a datastore? You''d do that in SQL''s dialect of DDL SQL, and
it is certainly possible, provided you have appropriate permissions.
Larry Linson
Microsoft Access MVP
"aaron kempf" <aa*********@gmail.com> wrote in message
news:2f**************************@posting.google.c om...
我发现ADP不支持任何使用
''CREATE PROC spHAPPY''语法的存储过程。
CREATE PROC语法在网上书籍中列出。
应该支持这种语法
这是一个场景：1）使用查询分析器创建proc和CREATE PROC spHAPPY语法
2）打开ADP中的这个过程
3）对proc进行更改
4）尝试保存并且你得到''参数不正确''错误。
我们可以请某人来解决这个问题;并停止给出借口??
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??
" aaron kempf" < AA ********* @ gmail.com>在留言中写道
新闻：2f ************************** @ posting.google.c om ...
"aaron kempf" <aa*********@gmail.com> wrote in message
news:2f**************************@posting.google.c om...
我发现ADP不支持任何使用''CREATE
PROC spHAPPY''语法的存储过程。
CREATE PROC语法在网上书籍中列出。
应该支持这种语法
这是一个场景：1）使用查询分析器创建proc和CREATE PROC spHAPPY语法
2）打开ADP中的这个过程
3）对proc进行更改
4）尝试保存并且你得到''参数不正确''错误。
我们可以请某人来解决这个问题;并停止给出借口??
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??
不是我们需要的，但我们有权给出尽可能多的借口。
这个怎么样：
我们不向那些不了解
存储过程和adp'的基础知识的人免费咨询。
，请不要多帖。
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.
哇。我并不认为这个
世界中剩下那么多白痴。
1）我在这个新闻组中双重发帖，因为MICROSOFT CENSORS他们
NEWSGROUP。
我刚学会了这个。
2）当然我知道ADP不会存储ADP文件中的sproc -
它位于SQL Server数据库中。
a）。使用''CREATE PROC SPHAPPY
AS SELECT * from SYSOBJECTS''
b）使用查询分析器创建一个sproc。在ADP和设计视图中打开此sproc，将其更改为
SELECT * FROM SYSOBJECTS WHERE XTYPE =''U''
c）。尝试保存您的更改;并且你会得到一个错误''参数
不正确''
我已经告诉微软这100次了;我必须每天处理这个错误每次10美元这个错误。
我只是很生气，因为微软无法解决这个问题。 br />
他们最赚钱的业务线。
更让我生气的是，你获得MVP不要知道
_ANYTHING_关于ADP。
SCREW MDB。 SCREW MVP'不知道ADP是什么。
Tom Travolta < to*@travolta.com>在消息新闻中写道：< co ********** @ hercules.btinternet.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 pisses me off that Microsoft can''t fix a serious problem in
their most profitable business line.
And what pisses 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" <to*@travolta.com> wrote in message news:<co**********@hercules.btinternet.com>...
" aaron kempf" < AA ********* @ gmail.com>在消息中写道
新闻：2f ************************** @ posting.google.c om ...
"aaron kempf" <aa*********@gmail.com> wrote in message
news:2f**************************@posting.google.c om...
我发现ADP不支持使用''CREATE
PROC spHAPPY''语法的任何存储过程。
CREATE PROC语法列在网上书籍中。
应该支持这种语法
这是一个场景：1）使用查询分析器创建proc和CREATE PROC spHAPPY语法
2）在ADP中打开此proc
3）对proc进行更改
4）尝试保存并且你得到''参数不正确''错误。
我们可以请别人来解决这个问题;并停止给出借口??
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??
不是我们需要的，但我们有权给出尽可能多的借口。
这个怎么样：
我们不向那些不了解存储过程和adp的基本知识的人免费咨询。
请不要多发帖子。
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.
这篇关于ADP中的CREATE PROC语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
