how to run paramterized queries

[Da Saint]

i have a stored procedure in sql server that asks for user to enter the
id so that users relevant data can be shown and then user can also
change the which ever data he or she wants, i tried ot incorporate that
query in infopath but it said not a valid query, cant we use the
paramyerized queries in infopath somehow, i need to do this and there
are lots of forms like this so i need to know about this ASAP, so i
will be waiting for replies all of u

 

[Henning Krause [MVP - Exhange]]

Hello,

The only way I know of is to this via script. You can access and modify the
data sources from code..

Greetings,
Henning Krause [MVP - Exchange]
==========================
Visit my website: http://www.infinitec.de
Try my free Exchange Explorer: Mistaya
(http://www.infinitec.de/software/mistaya.aspx)

 

[Scott L. Heim [MSFT]]

Hi,

There is Microsoft Knowledge Base article that, I believe, addresses your
question:

How to work with stored procedures by using script in an Office InfoPath
2003 form (827007)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;827007

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.