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).