Re: [sqlite] Get declared Datatype of SQLite Virtual Table

Igor Tandetnik wrote: > > "paul schindler" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> sqlite3_column_decltype("select amount from myvirtualtable", 0) >> returns "INTEGER" -> good! >> >> BUT: >> >> sqlite3_column_decltype("select sum(amount) from myvirtualtable", 0) >> retu

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

D. Richard Hipp wrote: > > > On Sep 5, 2008, at 9:03 AM, paul schindler wrote: > >> >> Hello, >> >> I have a virtual table and some (by me) declared datatypes are >> "TEXT10" or >> "INTEGER" or "DATE"... >> >> When I am using the function sqlite3_column_decltype() then I get >> those >> t

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

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.200

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

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 pre

[sqlite] bug in the RTree module

Hi, I think I have found a bug in the RTree extension (v3.6.2) a copy of the test database is available for download at: http://www.gaia-gis.it/rtreebug.zip [1.5 MB] - SQLite version 3.6.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables test sqli

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

Hello Lothar, yes, PRAGMA database_list will show you the database the handle is attaches with. Treat tis statement as a Select - Statement, ist returns at least one row of data, and the field "file" contains the filename of the database. Martin Lothar Behrens wrote: > It is a bit too complex

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

It is a bit too complex to show my code, because the sqlite2_* functions are wrapped two layers deeper than my code is using. Also the code is in a GUI that supports 'cursors'. Basically I can use the application and the table whose statement will fail to get any rows later, shows me the expec

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

Hello Lothar, sorry, i did not read your questions fully. No, after you get SQLITE_DONE, you do not have any data in your result set. After issuing sqlite_reset, you can not read any data, the statement Use the statement like this: - sqlite3_prepare the statement. - Use sqlite3_bind_xxx to set y

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

Hello Lothar, you should indeed get SQLITE_ROW. Can it be that your select statement has a where - clause that does not fir your data? Perhaps you want to post your statements here, beginning with create table. Martin Lothar Behrens wrote: > Hi, > > I am struggling with the following situation:

[sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

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 SQ

[sqlite] ICU 3.8 for SQLite 3.6.2 on windows host

Hello! You can get libSqliteIcu.dll and all needed libraries from http://dload.mobigroup.ru/sqlite-ext/icu/3.6.2/ Static and shared compiled ICU 3.8 libraries are here http://dload.mobigroup.ru/icu/3.8/ All binaries compiled by MinGW. Best regards, Alexey. __