[freetds] call a stored procedure and tds_submit_query
fabrizio.taretto at sinedita.it
Fri Jul 23 10:36:23 EDT 2004
...ok, but if I test the doneFlags, the error code is TDS_DONE_ERROR.
Is my syntax query wrong?
>> ...thanks a lot,
>> but I can't manage to use my stored procedure.
>> My stored procedure's definition is:
>> create procedure GetDraw(
>> @tes int,
>> @ted int,
>> @tfp varchar(20)
>> @ded varchar(10)
>> In my C source code I call:
>> tds_submit_query(gSocket, "exec GetDraw @tes=100, @ted=100,
>> @tfp='01010101', @ded='2004-03-03'");
>> tds_process_result_tokens(gSocket, &resulttype, &doneFlags)
>> ...but the result type is Always TDS_DONE_RESULT.
>> Where is my mistake?
> I don't suggest you to use libTDS directly (see
> http://www.freetds.org/which_api.html) however it's normal. Server it's
> just telling you that current recordset it's finished (with no rows
> returned in this case).
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS