SQL Database Integration

Re: SQL Statement (Customizing)

vapires — Wed, 25 Jan 2006 12:07:01 GMT

Thanks Matt!

There are only 10 types of people in the world - Those who understand binary, and those who don't.

Re: SQL Statement (Customizing)

Matt Faus — Wed, 25 Jan 2006 06:15:19 GMT

You can do custom SQL commands, but not that way. Check out this thread for a code example:

http://infopathdev.com/forums/topic.asp?TOPIC_ID=1612

---------------
Matt Faus
InfoPath Dev Texas

SQL Statement (Customizing)

vapires — Wed, 25 Jan 2006 02:33:24 GMT

Hi,
Is it possible to pass a variable from infopath to sql thru the dataconnection?
ie, When you go to tools-> data connections->Select your DC->Edit SQL -> is it possible to pass a variable thru here (where CID = @contactname)? And if so how is this done? I am trying to select certain records from the db based on a text nodevalue within the form and was wondering if there is anyway i can pass the textbox node value to the 2ndary connection via the SQL statemnent.

Any tips or help is appreciated.
Thanks,
Vidette

There are only 10 types of people in the world - Those who understand binary, and those who don't.