Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem retrieveing results from a query withan IMAGE field

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem retrieveing results from a query withan IMAGE field
  • Date: Thu, 5 Jun 2008 15:29:05 +0200

>
> Il giorno mer, 04/06/2008 alle 15.05 -0300, Daniel A. Veiga
> ha scritto:
> > This is the TDSDUMP log generated for the same program I sent the
> > unixODBC log file for. I hope it helps ...
> >
> > Daniel
> >
>
> it helps, it helps :)
>
> The code which cause the problem is in _SQLFetch
>
>
> /* TODO change when we code cursors support... */
> /* stop looping, forward cursor support only one row */
> num_rows = 1;
>
> well.. this tell to stop processing rows if an unbinded
> column is found.
> This is done to allow getting results using SQLGetData
> however we send a
> cursor fetch for 20 rows so in this case we have still to read 19 rows
> when SQLFetchScroll returns :(
>
> Well... for forward only cursors this is correct for perhaps
> for cursors
> is not... I think the correct processing should be fetch all
> 20 rows or
> request only a row (I think the last is the most probable)...
> I'll have
> to test.
>

commenting num_rows = 1 line seems to fix the problem. Under ODBC 2
SQLFetch returns only a row and does not take into account fetched_ptr,
array_size and status_ptr.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page