[freetds] call a stored procedure and tds_submit_query

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Jul 23 10:28:13 EDT 2004


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



More information about the FreeTDS mailing list