That is done by the wrapper class wrapping the sqlite API calls - as I  
understand.
It seems really that I don't have any data, because on failure a  
simple query without
where clause also fails.

As posted here, I'll see what the PRAGMA database_list gives me back.

Thanks,

Lothar

Am 07.09.2008 um 20:17 schrieb John Stanton:

> You get ROW if there is a row available, DONE if there are no rows, or
> all the rows have been extracted.  Your program needs to test for both
> states.
>
> Lothar Behrens wrote:
>> Hi,
>>
>> I am struggling with the following situation:
>>
>> I have a table where two rows are inserted. I create a new prepared
>> select statement to get a resultset.
>>
>> After getting the resultset I issue a sqlite3_step to see, if I hava
>> any data. Thus of two rows I assume to get
>> SQLITE_ROW.
>>
>> But I get SQLITE_DONE.
>>
>> My questions:
>>
>> After getting SQLITE_DONE, do I still have a row in my result set as
>> the last row for any sqlite3_step calls ?
>>
>> Is so, am I allowed to read the columns of this row after a
>> sqlite3_reset has been issued ?
>>
>> Is SQLITE_DONE a flag to be handled as the following SQLITE_ROW +
>> 'have the last row now' ?
>>
>> Thanks
>>
>> Lothar
>>
>> -- | Rapid Prototyping | XSLT Codegeneration | http:// 
>> www.lollisoft.de
>> Lothar Behrens
>> Heinrich-Scheufelen-Platz 2
>> 73252 Lenningen
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to