Re: Still can't process stored procedure results.

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@xxxxxxxxxxxxxxxxx
> 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