FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

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? Does myTable contain 'data1' and 'data2' ?

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