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 Error dialogue box says "Connectivity error: [MySQL][ODBC 5.1 Driver][mysqld-5.3.2-MariaDB] You have an error in your SQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use near 'select * from table2 limit3' at line 1" I know this works for SQL Server, but has anyone gotten the multiple results thingie working for non-SQL-Server backends? I'm sure but would enjoy the confirmation. Thanks. -- 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.
