El 25/03/12 10:38, MB Software Solutions, LLC escribió:
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
On 26/03/2012 12:58 AM, MB Software Solutions, LLC wrote:
I wasn't going to bother trying that, as T-SQL is SQL Server and I am
using MySQL. But, it didn't take much effort, so I did it since you
offered. Nope. No good. No different. Thanks though for trying.
I think Stephen was hinting
Just looked back and saw you were using the semi-colon to separate, but
do you need to force a separate line in there too?
Frank.
Frank Cazabon
On 26/03/2012 08:56 AM, Frank Cazabon wrote:
On 26/03/2012 12:58 AM, MB Software Solutions, LLC wrote:
I wasn't going to bother trying that, as
On Sun, Mar 25, 2012 at 11:58 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
I wasn't going to bother trying that, as T-SQL is SQL Server and I am
using MySQL. But, it didn't take much effort, so I did it since you
offered. Nope. No good. No different.
On Sat, Mar 24, 2012 at 10:55 AM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
VFP9SP2 calling a stored procedure in MariaDB (MySQL)
My stored procedure returns 6 cursors. Can the Fox handle getting
multiple cursors back? I thought so, by my SQLEXEC call
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
On 3/26/2012 9:06 AM, Frank Cazabon wrote:
Just looked back and saw you were using the semi-colon to separate, but
do you need to force a separate line in there too?
No, you shouldn't need to do that.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
My stored procedure returns 6 cursors. Can the Fox handle getting
multiple cursors back? I thought so, by my SQLEXEC call fails with
nothing showing when I do AERROR(laError).
I'm not sure if it's relevant. The following knowledgebase article seems to
imply that you need to use the CALL
On 3/26/2012 9:19 AM, Stephen Russell wrote:
On Sun, Mar 25, 2012 at 11:58 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
I wasn't going to bother trying that, as T-SQL is SQL Server and I am
using MySQL. But, it didn't take much effort, so I did it since
On 3/26/2012 10:00 AM, Ted Roche wrote:
Michael:
Which ODBC driver are you using? The Official Oracle/SUN/MySQL
driver added support for multiple statements (which I'd think you'd
need for multiple cursor return support, though I haven't tested it)
in version 3.51.22, according to
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:
H...so I'm wondering why
On Sun, Mar 25, 2012 at 8:38 AM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com 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
On 3/25/2012 10:29 PM, Stephen Russell wrote:
On Sun, Mar 25, 2012 at 8:38 AM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com 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
VFP9SP2 calling a stored procedure in MariaDB (MySQL)
My stored procedure returns 6 cursors. Can the Fox handle getting
multiple cursors back? I thought so, by my SQLEXEC call fails with
nothing showing when I do AERROR(laError).
I could have swore I was able to do this years ago (VFP5 or
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:
If the SQL statement generates one result set, SQLEXEC( ) stores the result set
to the specified Visual FoxPro cursor.
If the SQL
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:
H...so I'm wondering why this isn't working? Odd. Thanks.
--
Mike Babcock, MCP
16 matches
Mail list logo