[freetds] call a stored procedure and tds_submit_query
Thompson, Bill D (London)
bill_d_thompson at ml.com
Fri Jul 23 10:28:43 EDT 2004
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/>
==============================================================================
More information about the FreeTDS
mailing list