In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

PROCEDURE CADGER.nova can't return a result set in the given context: TMYSQLDATASOURCE

Xailer English public forum
Responder
claudio
Mensajes: 49
Registrado: Mar May 06, 2008 3:17 pm

PROCEDURE CADGER.nova can't return a result set in the given context: TMYSQLDATASOURCE

Mensaje por claudio »

Ao Executar o TMYSQLDATASOURCE:EXECUTE("CALL NOVA()") acontece o erro
abaixo:
PROCEDURE CADGER.nova can't return a result set in the given context:
TMYSQLDATASOURCE:EXECUTE
Alguem pode me ajudar ????
Claudio
Arriba
Rene Flores
Mensajes: 620
Registrado: Jue Mar 23, 2006 2:39 am

PROCEDURE CADGER.nova can't return a result set in the given context: TMYSQLDATASOURCE

Mensaje por Rene Flores »

claudio:
I'm exactly having the same result, please notice that when you are
using MySQL access via ADO, calling a Stored procedure works as
expected, the problem is when using the Xailer native client for MySQL.
Regards
Rene Flores
http://www.ciber-tec.com
escribió:
> Ao Executar o TMYSQLDATASOURCE:EXECUTE("CALL NOVA()") acontece o erro
> abaixo:
>
> PROCEDURE CADGER.nova can't return a result set in the given context:
> TMYSQLDATASOURCE:EXECUTE
>
> Alguem pode me ajudar ????
>
> Claudio
>
>
Arriba
new_indika
Mensajes: 32
Registrado: Jue Oct 16, 2008 12:59 pm

PROCEDURE CADGER.nova can't return a result set in the given context: TMYSQLDATASOURCE

Mensaje por new_indika »

Rene Flores escribió:
> claudio:
>
> I'm exactly having the same result, please notice that when you are
> using MySQL access via ADO, calling a Stored procedure works as
> expected, the problem is when using the Xailer native client for MySQL.
>
> Regards
>
> Rene Flores
> http://www.ciber-tec.com
>
> escribió:
>> Ao Executar o TMYSQLDATASOURCE:EXECUTE("CALL NOVA()") acontece o erro
>> abaixo:
>>
>> PROCEDURE CADGER.nova can't return a result set in the given context:
>> TMYSQLDATASOURCE:EXECUTE
>>
>> Alguem pode me ajudar ????
>>
>> Claudio
>>
I think that Execute method() doesn't allow returning result sets.If I
am right, it's a method to execute direct sentences on the database
whenever there is not resultset returned.
If you want to execute a stored procedure or function that return a
resultset, you must use methods like TAdoDataSource:Query() o
TAdoDataSource:QueryArray() that allows to return in a variable, a
dataset containing the result of the executed query.
If I'm not mistaken, this will happen independently of class used (TAdo
or ative controls).
Arriba
Responder

Volver a “English”