freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] call a stored procedure and tds_submit_query
- From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.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 15:28:43 +0100
Hi fabrizio,
If we could have a snippet of the TDSDUMP log, it would help us to see
what's happening.
Bill
-----Original Message-----
From: Fabrizio Taretto [mailto:fabrizio.taretto AT sinedita.it]
Sent: 23 July 2004 15:15
To: FreeTDS Development Group
Subject: Re: [freetds] call a stored procedure and tds_submit_query
...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
> Hi Fabrizio,
>
> Yes you can do this - you would just construct a statement "exec
> sp_myproc
> @parameter = 'value'" and submit it as you would a "select * from
> mytable"
> or "update mytable set column = 'value'" statement.
> If the stored procedure returns a result set, then it can be processed
> just
> as if it were the result set from a "select * from mytable" statement.
>
> The only proviso is with stored procedure OUTPUT parameters.
> If you are talking to sql server 2000 sp3, then these will not be
> returned
> to the client.
>
> HTH,
>
> Bill
>
> -----Original Message-----
> From: Fabrizio Taretto [mailto:fabrizio.taretto AT sinedita.it]
> Sent: 23 July 2004 10:58
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] call a stored procedure and tds_submit_query
>
>
> Hi All,
>
> someone can tell me if it's possible call a stored procedure with
> tds_submit_query and process result with tds_process_result_tokens.
> These functions are perfect for SELECT and UPDATE but what can I use
> for a stored procedure?
> Can anybody help me?
>
> I'm work on MacOS X 10.3.4.
>
> Regards
> Fabrizio
> _______________________________________________
> 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/>
>
> =======================================================================
> =======
>
> _______________________________________________
> 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/>
==============================================================================
-
[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.