how to set the data connection to completed SQL string

[Paul Mayer]

Okay, I built the Dynamic SQL Statment using the concat function in a text
varible MySQL(I understand the conecpt of Dynamic SQL. I have several follow
up questions now do I set the data connection with the completed sql string?
Do you mean paste the concat statement into the where I edit the sql
statement in the data connection wizard or some other methiod of changing the
data connection? Does it matter whether the date is in the format 2008-03-01
when it is passed to the back end access data tables or does it need to be
formated 03/01/2008 for it to return back results? BTW, I am using IP 2003
nad Access 2003 data table for my data connection..

You need to build your SQL string first, by concatenating the SQL code with
the values from your selectSingleNode statements.

Then set your data connection with the completed SQL string.

--
Greg Collins
Microsoft MVP
Visit Braintrove at http://www.braintrove.com
Visit InfoPathDev at http://www.infopathdev.com

Was this

 

[Greg Collins]

InfoPath does not support MySQL without a Web Service. MS SQL it does
support.

Your data connection will have a property where you can assign your updated
SQL statement before executing/querying the connection.

MS SQL will accept the XML sortable date format: 2008-03-01