Re: [sqlite] cursor question
Cursors as such are not implemented. You can achieve the function of a cursor from Sqlite with some thought. Jim Crafton wrote: Does the latest version of sqlite have cursors? If so, where might I find docs on using them? Thanks Jim C - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3 close() run time errors
I used borland IMPLIB import tool with -a attribute (this add the leading underscore for cdecl compliance). If I didn't use this flag I got linking error about missing references... this's a run-time error not a linker error. - Original Message - From: Roberto [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, December 11, 2006 3:59 PM Subject: Re: [sqlite] sqlite3 close() run time errors You are probably linking against exports with a leading underscore. (The exports of sqlite3.dll don't have the _underscore). Does your dev environment/linker have the option to disable this underscore generation? On 11/12/06, Michele Santucci [EMAIL PROTECTED] wrote: Hello, I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I took the last sqlite3 dll and source. I create the .lib file linked it to the binary and included the sqlite3.h file... but as long as I start the application I got an error about a missing entry point of the _sqlite3_close() function... why? May depends on mscvrt dependancies? Distinti saluti, Michele Santucci = Software Development Manager * Celin Avio s.r.l. * tel. +39-0187933876 fax +39-0187933654 web: http://www.celinavio.it = - To unsubscribe, send email to [EMAIL PROTECTED] - -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.15/581 - Release Date: 09/12/2006 15.41 - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3 close() run time errors
See the answer to 'Roberto' in the same thread I create the .lib trough Borland IMPLIB with the proper flag to add leading _underscores. - Original Message - From: Marten Feldtmann [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, December 11, 2006 3:55 PM Subject: Re: [sqlite] sqlite3 close() run time errors Michele Santucci schrieb: Hello, I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I took the last sqlite3 dll and source. I create the .lib file linked it to the binary and included the sqlite3.h file... but as long as I start the application I got an error about a missing entry point of the _sqlite3_close() function... why? Calling convention and name decoration. Your linker knows, that sqlite3_close() has to be called via cdecl calling convention and does not look for sqlite_close(), but for _sqlite_close(). You have to tell your IDE, Linker - that it should not use naming decoration. Marten - To unsubscribe, send email to [EMAIL PROTECTED] - -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.15/581 - Release Date: 09/12/2006 15.41 - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3 close() run time errors
On 12/12/06, Michele Santucci [EMAIL PROTECTED] wrote: this's a run-time error not a linker error. It sounds like a load time error. If that's the case, and it is the Windows loader, then your import tool did not do translation correctly: it's looking for the literal name _sqlite3_open in the DLL exports. Such a name does not exist. The Microsoft import library format sets up name translations, where the underscore is supplied for the usual linking mechanisms, but the linker is also instructed to place the undecorated name in the dependency table. You want to have your tool do the same thing. Failing that, look for a way to have the compiler not apply decorations to dllimport function declarations. One of those must be supported, since it would be required to use Windows API functions (stdcall has a decoration format of its own). Failing that, give up on the stock dll and build your own, or compile sqlite directly into your project :) - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3 close() run time errors
On 12/12/06, Michele Santucci [EMAIL PROTECTED] wrote: this's a run-time error not a linker error. It's a runtime error cos it is linked incorrectly! Specify the sqlite.def file (which IIRC lists the undecorated aliases of the sqlite functions) as an option to the command line of implib. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] update across multiple tables
Hi I have the following update statements that work fine on mysql. I understand that sqllite will not do the table join so how would I do this update without resorting to multiple sub-queries UPDATE shopstatistics as s, Temp_Shop_Stats_1 as Temp SET s.nbrdailiesmorning = Temp.nbrdailiesmorning, s.nbrdailiesevening = Temp.nbrdailiesevening, s.nbrweeklies = Temp.nbrweeklies, s.nbrmonthlies = Temp.nbrmonthlies, s.nbrothers = Temp.nbrothers, s.valuedailiesmorning = Temp.valuedailiesmorning, s.valuedailiesevening = Temp.valuedailiesevening, s.valueweeklies = Temp.valueweeklies, s.valuemonthlies = Temp.valuemonthlies, s.valueothers = Temp.valueothers WHERE s.day = Temp.day and s.shopid = Temp.shopid and s.phase = 0; Chris Hoy - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] multiple order by value bug?
Hi list, sqlite version: 3.3.8 I have 2 tables: --- CREATE TABLE kereset (realid INTEGER NOT NULL, id INTEGER NOT NULL, datum DATETIME, jogcim CHAR(1) NOT NULL, brutto INT NOT NULL, ado INT NOT NULL, adoalap INT NOT NULL); CREATE TABLE szemely (id INTEGER NOT NULL, nev VARCHAR(128) NOT NULL COLLATE MAGYAR, leanynev VARCHAR(128) COLLATE MAGYAR, anyanev VARCHAR(128) COLLATE MAGYAR, szulhely VARCHAR(128) COLLATE MAGYAR, szuldat DATETIME, adoszam VARCHAR(10), irszam INT, varos VARCHAR(64) COLLATE MAGYAR, cim VARCHAR(128) COLLATE MAGYAR, telefon VARCHAR(64), adoalap INT, adosav INT, szolgdij INT, torolve BOOLEAN DEFAULT FALSE); --- my query: --- SELECT szemely.nev, szemely.anyanev, szemely.szulhely, szemely.adoszam, kereset.datum,szemely.id FROM szemely,kereset WHERE (kereset.datum = 19950101 AND kereset.datum = 19951231) AND (szemely.nev = '000' AND szemely.nev = 'zzz') AND kereset.id = szemely.id ORDER BY szemely.nev,szemely.anyanev --- This query works fine (I think my collate function too), but if I accomodate it with ORDER BY szemely.nev,szemely.anyanev,kereset.datum, then sorting is in wrong order. If you need it, I send my collate function. regards --- kiru - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] multiple order by value bug?
On 12/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: This query works fine (I think my collate function too), but if I accomodate it with ORDER BY szemely.nev,szemely.anyanev,kereset.datum, then sorting is in wrong order. Do you mean you have two ORDER BY clauses? Seems like that would be a syntax error, or, at best, undefined. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqllite ddb from win to linux
hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here?
Re: [sqlite] sqllite ddb from win to linux
Rob Coenen [EMAIL PROTECTED] wrote: hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here? Use sqlite to read an sqlite version 2 database. Use sqlite3 to read a version 3 database. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
Rob Coenen wrote, hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here? The first thing that comes to mind is to dump the database to text and then, open a new one in unix and import it. just thinking... - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
yes that is what I tried; I did use sqlite3 does not work. Any known problems on moving db files from Win to Linux? On 12/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Rob Coenen [EMAIL PROTECTED] wrote: hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here? Use sqlite to read an sqlite version 2 database. Use sqlite3 to read a version 3 database. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
ok - I was trying to do somthing like this, but I could not find any sample? On 12/12/06, jose isaias cabrera [EMAIL PROTECTED] wrote: Rob Coenen wrote, hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here? The first thing that comes to mind is to dump the database to text and then, open a new one in unix and import it. just thinking... - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
Rob Coenen [EMAIL PROTECTED] wrote: yes that is what I tried; I did use sqlite3 does not work. Any known problems on moving db files from Win to Linux? SQLite database files are cross-platform. They work on linux, windows, mac, various embedded platforms, etc. Byte order does not matter either. Perhaps the file was corrupted by whatever utility you used to move it from win to Linux? Perhaps \n got converted to \r\n or something. Can you compare the md5 checksum of the file before and after moving it? -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Loss of table feature.. ever?
Hello people, i really need to ask this thing again. My visual design tool has a custom written datacontrol for sqlite. This means MoveFirst, Previous, next and movelast buttons. This control depends heavily on the gettable() sqlite functions. While i already understand that these functions are deprecated and we should use the prepare stuff. I do that already except for this control. At this time the prepare stuff does not seem to work the same as the table stuff. Like moveprevious and such? I don't mind, the table stuff is good for me, i'm only want to let you know that some of us are depending on this stuff. Hope you'll leave this part in? Thanks! - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: Loss of table feature.. ever?
Edwin Knoppert [EMAIL PROTECTED] wrote: Hello people, i really need to ask this thing again. My visual design tool has a custom written datacontrol for sqlite. This means MoveFirst, Previous, next and movelast buttons. This control depends heavily on the gettable() sqlite functions. While i already understand that these functions are deprecated and we should use the prepare stuff. I do that already except for this control. At this time the prepare stuff does not seem to work the same as the table stuff. Like moveprevious and such? sqlite3_get_table simply loads the whole resultset into memory. You can do that with sqlite3_prepare et al just as well. In fact, sqlite3_get_table is implemeted in terms of sqlite3_prepare, sqlite3_step and so on. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: Loss of table feature.. ever?
Yes but imo a rather daunting task. I better leave it to the author of sqlite :) - Original Message - From: Igor Tandetnik [EMAIL PROTECTED] To: SQLite sqlite-users@sqlite.org Sent: Tuesday, December 12, 2006 8:01 PM Subject: [sqlite] Re: Loss of table feature.. ever? Edwin Knoppert [EMAIL PROTECTED] wrote: Hello people, i really need to ask this thing again. My visual design tool has a custom written datacontrol for sqlite. This means MoveFirst, Previous, next and movelast buttons. This control depends heavily on the gettable() sqlite functions. While i already understand that these functions are deprecated and we should use the prepare stuff. I do that already except for this control. At this time the prepare stuff does not seem to work the same as the table stuff. Like moveprevious and such? sqlite3_get_table simply loads the whole resultset into memory. You can do that with sqlite3_prepare et al just as well. In fact, sqlite3_get_table is implemeted in terms of sqlite3_prepare, sqlite3_step and so on. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] building sqlite on windows in Unicode
Hi, Building sqlite on windows in Unicode mode broke with the addition of the loadable extensions. I found a bug matching this problem and attached a patch to it to fix it a while ago, however I haven't seen any other comments or movement in the bug. I'm not sure what else needs to be done to have a patch accepted, so I'm posting here in the hope to prod it along for review or acceptance. The problem is that the dlopen/LoadLibrary code looks like it was hacked in instead of being added to the platform abstraction API and it doesn't support windows unicode builds out of the box. The patch fixes that problem and silences a warning generated by the new index format. bug... http://www.sqlite.org/cvstrac/tktview?tn=2023 patch... http://www.sqlite.org/cvstrac/attach_get/309/sqlite3.patch Regards, Brodie - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: Re: Loss of table feature.. ever?
Edwin Knoppert [EMAIL PROTECTED] wrote: Yes but imo a rather daunting task. I better leave it to the author of sqlite :) You can download SQLite source code and check the implementation. I expect sqlite3_get_table is implemented in a couple dozen lines of code. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
On Tue, 12 Dec 2006 19:25:16 +0100, you wrote: ok - I was trying to do somthing like this, but I could not find any sample? sqlite3 olddatabasefile .dump transportfile [transfer transportfile in binary mode] sqlite3 newdatabasefile transportfile On 12/12/06, jose isaias cabrera [EMAIL PROTECTED] wrote: Rob Coenen wrote, hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here? The first thing that comes to mind is to dump the database to text and then, open a new one in unix and import it. just thinking... - To unsubscribe, send email to [EMAIL PROTECTED] - -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite3 close() run time errors
Michele Santucci wrote: I used borland IMPLIB import tool with -a attribute (this add the leading underscore for cdecl compliance). If I didn't use this flag I got linking error about missing references... this's a run-time error not a linker error. Michele, This is a problem I discovered with Borland IMPLIB. The fix I found is described under ticket 1291 at http://www.sqlite.org/cvstrac/tktview?tn=1291 For some reason implib doesn't generate the correct symbols when converting directly from the dll file. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] creating indices from my app vs sqlite3.exe
___BACKUP INFO___ I've got a single database, with about 10,000 records (the file is 944KB). I have a feature that will re-populate the database from external disk files. If the database is already populated, then the feature just walks the disk files and validates that each file is already in the database. IF I have good indices, the feature takes about 5 seconds to run. IF I have bad indices, the feature takes about 2-5 minutes to run. ___PROBLEM INFO___ If I create 1 index from my app, the feature runs fast. CREATE INDEX foldername_index ON cabs (foldername); If I create 2 indices from my app, the feature runs REAL slow. CREATE INDEX foldername_index ON cabs (foldername); CREATE INDEX cuid_index ON cabs (cuid,duid); If I create 1 or 2 indices from sqlite3.exe on my database, then the feature runs REAL FAST! ___WRAP UP___ I've been working on this all day, with little success to deterine the difference. Any ideas? My app does the following, on an already populated database: Note: I'm using CppSQLite3 as a wrapper. sqlite3_exec(m_pDB, CREATE INDEX foldername_index ON cabs (foldername);, 0, 0, err); sqlite3_exec(m_pDB, CREATE INDEX cuid_index ON cabs (cuid,duid);, 0, 0, err); Any ideas why the creation of the SECOND index makes everything stop working right? Thanks DanB - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] multiple order by value bug?
Will Leshner írta: On 12/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: This query works fine (I think my collate function too), but if I accomodate it with ORDER BY szemely.nev,szemely.anyanev,kereset.datum, then sorting is in wrong order. Do you mean you have two ORDER BY clauses? Seems like that would be a syntax error, or, at best, undefined. No, I accomodate only te kereset.datum colum to the ORDER BY clause, and then the result come wrong. The two columns (szemely.nev,szemely.anyanev) collated by my func, and the third column that I accomodate is collated by the default sqlite func. I want to sort by szemely.nev and when szemely nev is equal, sort by szemely.anyanev. Then I would like to sort the result by kereset.datum. nev|anyanev|datum 1. aaa|bbb|111 2. aaa|bbb|112 3. aaa|bbc|111 4. aaa|bbc|112 regards --- kiru - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Copy Table Values
I want to copy field values for two columns in one table into the equivalent columns in another table. I don't find a 'select ... into' option in the web page syntax for the command. How should I go about doing this data copy? Thanks, Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator http://www.appl-ecosys.com Voice: 503-667-4517 Fax: 503-667-8863 - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Copy Table Values
Rich Shepard [EMAIL PROTECTED] wrote: I want to copy field values for two columns in one table into the equivalent columns in another table. I don't find a 'select ... into' option in the web page syntax for the command. How should I go about doing this data copy? INSERT INTO ... SELECT ... -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Copy Table Values
On Tue, 12 Dec 2006, [EMAIL PROTECTED] wrote: INSERT INTO ... SELECT ... A-ha! Thank you very much. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator http://www.appl-ecosys.com Voice: 503-667-4517 Fax: 503-667-8863 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] multiple order by value bug?
I also have an issue with Order By with one of my queries as well. I am doing a multi field Order By and the second of the two fields does not sort in the correct order. I do not have the code in front of me, so can't supply any details. I have been killing bigger alligators on that project so the Order By issue is on the to do list. I just figured it was my Select statement, although it is pretty straight forward, as I remember. Perhaps there is a bug report in the making. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 2:41 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] multiple order by value bug? Will Leshner írta: On 12/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: This query works fine (I think my collate function too), but if I accomodate it with ORDER BY szemely.nev,szemely.anyanev,kereset.datum, then sorting is in wrong order. Do you mean you have two ORDER BY clauses? Seems like that would be a syntax error, or, at best, undefined. No, I accomodate only te kereset.datum colum to the ORDER BY clause, and then the result come wrong. The two columns (szemely.nev,szemely.anyanev) collated by my func, and the third column that I accomodate is collated by the default sqlite func. I want to sort by szemely.nev and when szemely nev is equal, sort by szemely.anyanev. Then I would like to sort the result by kereset.datum. nev|anyanev|datum 1. aaa|bbb|111 2. aaa|bbb|112 3. aaa|bbc|111 4. aaa|bbc|112 regards --- kiru -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] multiple order by value bug?
On 12/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: No, I accomodate only te kereset.datum colum to the ORDER BY clause, and then the result come wrong. Ah. Ok. Sorry for the confusion. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
Could be an FTP in ASCII mode copy problem. [EMAIL PROTECTED] wrote: Rob Coenen [EMAIL PROTECTED] wrote: yes that is what I tried; I did use sqlite3 does not work. Any known problems on moving db files from Win to Linux? SQLite database files are cross-platform. They work on linux, windows, mac, various embedded platforms, etc. Byte order does not matter either. Perhaps the file was corrupted by whatever utility you used to move it from win to Linux? Perhaps \n got converted to \r\n or something. Can you compare the md5 checksum of the file before and after moving it? -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] SQLiteJDBC is now 100% Pure Java
For several months now I have been providing a Java JDBC driver for SQLite 3. Now I am happy to announce with v030, the completion of a 100% Pure Java version. http://www.zentus.com/sqlitejdbc This is accomplished with the support of the great NestedVM project. The SQLite C source is compiled by gcc to a MIPS binary, that is then dynamically interpreted on top of the Java runtime. This involves a performance hit but greatly simplifies inclusion in current projects and delivery cross-platform. The native JNI version has not been abandoned, and binaries are still provided for Windows and Mac OS X. Linux can be directly compiled. The new native version has been extensively tested, with the only major caveat at the moment being the size of the binary. I believe it can be greatly reduced from the current ~ 800kb, I just do not have the time. I hope someone finds this useful. The code is all under a BSD license. d - To unsubscribe, send email to [EMAIL PROTECTED] -