FreeTDS Development Group

[Jeff Dahl <jddahl AT micron.com>]

Frediano Ziglio wrote:

> Il giorno ven, 10/02/2006 alle 18.01 -0700, Jeff Dahl ha scritto:
>  
>
> > Why does this query
> >
> >    CREATE TABLE #data( myID varchar( 25 ))
> >    INSERT into #data select myID from myTable where myID = 'data1'
> >    INSERT into #data select myID from myTable where myID = 'data2'
> >    CREATE index myindex on #data (myID)
> >    SELECT myID
> >    FROM #data, myTable
> >    WHERE ( #data.myID = myTable.myID )
> >    DROP TABLE #data
> >
> > generate this error:
> >
> >    SQL_STATE: 24000
> >    NATIVE_ERROR: 0
> >    MSG: [FreeTDS][SQL Server]Invalid cursor state
> >    MSG_LEN: 41
> >
> > I've tried this with both 0.63 and the latest CVS version.  Only the CVS
> > version gives the error.  Version 0.63 doesn't return anything.
> >
> > Thanks,
> > Jeff Dahl
> >
> >    
>
> Is difficult do reply to your question without knowing the tool you are
> using... I suppose is a ODBC tool like isql. Or is it a program you
> wrote? 
I wrote the program using the ODBC API.  However, if I run the same 
query with with tsql (v0.63 and CVS), the data is returned correctly.  
Looks like the problem is in the ODBC layer.

> Does myTable contain 'data1' and 'data2' ?
>  
Yes.

> 0.63 version reply is wrong, while CVS is a bit... futuristic... We
> already started a new branch so CVS is not the next coming release but
> the release AFTER the coming release... However fixing problem before
> any release is feasible...
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>