On Sun, Mar 25, 2012 at 8:38 AM, MB Software Solutions, LLC <[email protected]> wrote: > On 3/25/2012 12:46 AM, MB Software Solutions, LLC wrote: >> On 3/24/2012 12:04 PM, Rick Schummer wrote: >>>>> My stored procedure returns 6 cursors. Can the Fox handle getting >>>>> multiple cursors back?<< >>> >>> Absolutely, straight from the SQLEXEC() entry in the VFP Help file: >> >> >> Hmmmm...so I'm wondering why this isn't working? Odd. Thanks. >> >> > > Must be a limitation with the ODBC driver for this MariaDB database. > I'm doing this simple test: > > lcSQL = 'select * from table 1 limit 2;' > ? sqlexec(giHandle,lcSQL) && this works fine > > lcSQL = lcSQL + " select * from table2 limit 3" > ? sqlexec(giHandle,lcSQL) && this fails > ------------------
try lcSQL = 'select * from table 1 limit 2; Go;' Go works in TSQL. You may have another syntax in this other DB? -- Stephen Russell 901.246-0159 cell _______________________________________________ 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/CAJidMY+UNPct+1ataE4MAR_V=11rsjoa2fcflxpcetjch4d...@mail.gmail.com ** 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.
