 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2008how to set the data connection to completed SQL string
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.. "Greg Collins" wrote: > 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. Was this 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  SignatureGreg Collins Microsoft MVP Visit Braintrove at http://www.braintrove.com Visit InfoPathDev at http://www.infopathdev.com
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.