Skip to Content.
Sympa Menu

freetds - Re: [freetds] Still can't process stored procedure results.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Vanns <jimv AT canterbury.ac.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Still can't process stored procedure results.
  • Date: Tue, 19 Aug 2003 09:47:17 +0100

Thanks! Got it!

Jim

On Mon, 2003-08-18 at 19:26, Frediano Ziglio wrote:
> Il lun, 2003-08-18 alle 15:12, James Vanns ha scritto:
> > OK, I understand that M$ SQL Server (2000) outputs the results of stored
> > procedures in two different ways depending on how the sproc is written.
> > It can return a result set or print out the fields directly (to stdout
> > if you like!).
> >
> > I can retrieve (using the TDS library) the results of a sproc if it is a
> > result-set. However I cannot if it is printed to the 'screen'. I am
> > switching on the directives below:
> >
> > <snip>
> > results = socket->res_info;
> >
> > if (results)
> > switch (result_type) {
> > case TDS_ROWFMT_RESULT:
> > case TDS_COMPUTEFMT_RESULT:
> > for (int i = 0 ; i < results->num_cols ; i++)
> > headers.push_back (results->columns[i]->column_name);
> >
> > break;
> > case TDS_ROW_RESULT:
> > case TDS_COMPUTE_RESULT:
> > while (tds_process_row_tokens (socket, &row_type, &id) ==
> > TDS_SUCCEED) {
> > vector<string> row;
> > for (int i = 0 ; i < results->num_cols ; i++)
> > row.push_back (field_as_string (i));
> >
> > result_set.push_back (row);
> > }
> > break;
> > }
> >
> > </snip>
> >
> > I am using the latest FreeTDS source and protocol version 8. Any ideas
> > on how I can see the results of a sproc that simply prints its output?
> >
> > Many thanks.
> >
> > James Vanns
>
> prints its output ??
> If you mean "print" statement register a message handler an print
> message (see tsql.c for an example). However I don't recommend you to
> use libTDS directly. Is subject to change without notice cause its use
> is mainly be the core of other libraries (ctlib, dblib and odbc)
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
James Vanns BSc (Hons) MCP
Linux Systems Administrator
Senior Software Engineer (Linux / C & C++)
Canterbury Christ Church University College
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370





Archive powered by MHonArc 2.6.24.

Top of Page