On 3/26/2012 8:56 AM, Frank Cazabon wrote: > I think Stephen was hinting that you need to make sure that you are > using the correct syntax for your backend database. It looks to me like > you build up a string of selects without any sort of indication that > they are separate selects. In effect you are building up this: > > Select myfields1 from table 1 select myfields 2 from table 2 select > myfields3 from table3 > > I would expect any backend to choke on that, so you need to try it like > building up your sql command like this: > > Select myfields1 from table 1 > > select myfields 2 from table 2 > > select myfields3 from table3 > > using any line terminator that MySQL expects. > > Of course you may have it formatted like this already, but the sample > code you gave doesn't give that impression
Hi Frank, The semicolon is the separator. Running this fails as I said in an earlier post in this thread: sqlexec(giHandle,'select * from table1; select * from table2;') And I tried it without the final semicolon too. Same results. Thanks, though. --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
