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 th
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
> h
On 3/26/2012 9:19 AM, Stephen Russell wrote:
> On Sun, Mar 25, 2012 at 11:58 PM, 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.
On Mon, Mar 26, 2012 at 12:49 PM, Christof Wollenhaupt
wrote:
>>
>> 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 foll
>
> 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 CAL
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
http://
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
On Sat, Mar 24, 2012 at 10:55 AM, MB Software Solutions, LLC
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 fails with
> nothing showing when I do AERRO
On Sun, Mar 25, 2012 at 11:58 PM, 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.
--
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, a
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 t
On 3/25/2012 10:29 PM, Stephen Russell wrote:
> On Sun, Mar 25, 2012 at 8:38 AM, MB Software Solutions, LLC
> 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 gettin
On Sun, Mar 25, 2012 at 8:38 AM, MB Software Solutions, LLC
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,
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'
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 Babco
>> 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
16 matches
Mail list logo