有关存储过程参数的ADP问题 [英] ADP question about stored proc parameters
问题描述
好的，我知道我已经做到了，但似乎不再为我工作了
。
我有一个基于存储过程的表单，usp_PubsAuthors
并且它有一个参数@FilterState varchar（2）
默认为CA.我在表单上放了一个组合框，其中包含一个列表
状态，并将其命名为param，FilterState。
这不应该是......自动谈判，如Aaron Kempf
说？我已经看到了这项工作，但它已经不再适用了。有没有
一些简单的步骤我不见了？
Danny Lesandrini
2007年7月16日星期一18:24:04 -0600，dlesandrini
< da ****** @ comcast.netwrote：
在InputParametersProperty中写：
@ FilterState = Forms！YourForm！YourCombobox
-Tom。
>好的，我知道我已经做到了这一点，但对我来说似乎不再适用于我。
我有一张表格基于存储过程usp_PubsAuthors
它有一个参数@FilterState varchar（2），它默认为CA.我在表单上放了一个带有状态列表的组合框，并将其命名为param，FilterState。
这不应该......自动协商，如同Aaron Kempf说什么？我已经看到了这项工作，但它已经不再适用了。是否有一些简单的步骤我不见了？
Danny Lesandrini
是的，那是'我做了什么，但我认为另一种方法是有效的，并且
Aaron Kempf曾说他只使用它。它有一些优点。
如果你看看它的输入参数属性会失去它的价值 -
眼睛。另外，我讨厌引用这样的表格。它不是那么可以重复使用。
无论如何，我正在为丹佛地区访问的演示文稿准备信息
用户组这个星期四，我只想展示各种
方法。我确信这是可能的，但也许不是。
Danny
Tom van Stiphout < no ************* @ cox.netwrote in message news：4q ************************* ******* @ 4ax.com ...
周一，2007年7月16日18:24:04 -0600，dlesandrini
< da ****** @ comcast.netwrote：
在InputParametersProperty中写：
@ FilterState = Forms！ YourForm！YourCombobox
-Tom。
>>好的，我知道我已经这样做了，但是它对我来说似乎不再适用。
我有一个基于存储过程的表单，usp_PubsAuthors
它有一个参数，@ FilterState varchar（ 2）
默认为CA.我在表单上放了一个带有状态列表的组合框，并将其命名为param，FilterState。
这不应该......自动协商，如同Aaron Kempf说什么？我已经看到了这项工作，但它已经不再适用了。是否有一些简单的步骤我不见了？
Danny Lesandrini
< BLOCKQUOTE>" dlesandrini" < da ****** @ comcast.netwrote：
>无论如何，我正在为丹佛地区访问的演示文稿准备信息
本周四用户组，
Sco Scofield是否参加了这些活动？如果是这样，请打个招呼。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以阅读整个邮件主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
Tony的Microsoft Access博客 - http://msmvps.com/blogs/access/
Ok, I know I''ve done this, but it doesn''t seem to work
for me anymore.
I have a form based on a stored proc, usp_PubsAuthors
and it has a single parameter, @FilterState varchar(2) which
defaults to CA. I put a combo box on the form with a list
of states, and named it to the param, FilterState.
Isn''t this supposed to ... auto-negotiate, as Aaron Kempf
says? I''ve seen this work, but it no longer does. Is there
some simple step I''m missing?
Danny Lesandrini
On Mon, 16 Jul 2007 18:24:04 -0600, "dlesandrini"
<da******@comcast.netwrote:
In the InputParametersProperty write:
@FilterState=Forms!YourForm!YourCombobox
-Tom.
>Ok, I know I''ve done this, but it doesn''t seem to work
for me anymore.
I have a form based on a stored proc, usp_PubsAuthors
and it has a single parameter, @FilterState varchar(2) which
defaults to CA. I put a combo box on the form with a list
of states, and named it to the param, FilterState.
Isn''t this supposed to ... auto-negotiate, as Aaron Kempf
says? I''ve seen this work, but it no longer does. Is there
some simple step I''m missing?
Danny Lesandrini
Yeah, that''s what I did, but I thought the other method worked, and
Aaron Kempf had said he used it exclusively. It has some advantages.
That InputParameter property loses it''s value if you look at it cross-
eyed. Plus, I hate referencing forms like that. It''s not so reuseable.
Anyhow, I''m preparing info for a presentation at the Denver Area Access
User''s Group this Thursday, and I just wanted to demonstrate the various
methods. I was sure it was possible, but maybe it''s not.
Danny
"Tom van Stiphout" <no*************@cox.netwrote in message news:4q********************************@4ax.com...On Mon, 16 Jul 2007 18:24:04 -0600, "dlesandrini"
<da******@comcast.netwrote:
In the InputParametersProperty write:
@FilterState=Forms!YourForm!YourCombobox
-Tom.
>>Ok, I know I''ve done this, but it doesn''t seem to work
for me anymore.
I have a form based on a stored proc, usp_PubsAuthors
and it has a single parameter, @FilterState varchar(2) which
defaults to CA. I put a combo box on the form with a list
of states, and named it to the param, FilterState.
Isn''t this supposed to ... auto-negotiate, as Aaron Kempf
says? I''ve seen this work, but it no longer does. Is there
some simple step I''m missing?
Danny Lesandrini
"dlesandrini" <da******@comcast.netwrote:
>Anyhow, I''m preparing info for a presentation at the Denver Area Access
User''s Group this Thursday,Does Sco Scofield attend those? If so please say hi.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony''s Microsoft Access Blog - http://msmvps.com/blogs/access/
这篇关于有关存储过程参数的ADP问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
