freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] call a stored procedure and tds_submit_query
- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] call a stored procedure and tds_submit_query
- Date: Fri, 23 Jul 2004 16:28:13 +0200
>
> ...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] call a stored procedure and tds_submit_query,
Fabrizio Taretto, 07/23/2004
- <Possible follow-up(s)>
-
RE: [freetds] call a stored procedure and tds_submit_query,
Thompson, Bill D (London), 07/23/2004
- Re: [freetds] call a stored procedure and tds_submit_query, Fabrizio Taretto, 07/23/2004
-
RE: [freetds] call a stored procedure and tds_submit_query,
ZIGLIO, Frediano, VF-IT, 07/23/2004
- Re: [freetds] call a stored procedure and tds_submit_query, Fabrizio Taretto, 07/23/2004
- RE: [freetds] call a stored procedure and tds_submit_query, Thompson, Bill D (London), 07/23/2004
-
RE: [freetds] call a stored procedure and tds_submit_query,
Thompson, Bill D (London), 07/23/2004
- Re: [freetds] call a stored procedure and tds_submit_query, Fabrizio Taretto, 07/23/2004
-
RE: [freetds] call a stored procedure and tds_submit_query,
Thompson, Bill D (London), 07/23/2004
- Re: [freetds] call a stored procedure and tds_submit_query, Fabrizio Taretto, 07/23/2004
- RE: [freetds] call a stored procedure and tds_submit_query, Thompson, Bill D (London), 07/23/2004
Archive powered by MHonArc 2.6.24.