[freetds] call a stored procedure and tds_submit_query

Thompson, Bill D (London) bill_d_thompson at ml.com
Fri Jul 23 10:41:25 EDT 2004


Fabrizio,

If you capture a TDSDUMP, you should be able to see whats happening....

Bill

-----Original Message-----
From: Fabrizio Taretto [mailto:fabrizio.taretto at sinedita.it] 
Sent: 23 July 2004 15:36
To: FreeTDS Development Group
Subject: Re: [freetds] call a stored procedure and tds_submit_query


...ok, but if I test the doneFlags, the error code is TDS_DONE_ERROR.
Is my syntax query wrong?

Fabrizio

>>
>> ...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?
>>
>> Regards
>> Fabrizio
>>
>
> 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).
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
     <http://www.ml.com/email_terms/>

==============================================================================




More information about the FreeTDS mailing list