[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

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,

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

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

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 Voice:

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

[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

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"

[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

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

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 On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >>

[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

[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

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" Sent: Tuesday, December 12, 2006 8:01 PM Subject: [sqlite] Re: Loss of table feature.. ever? Edwin

[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

[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

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

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

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

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

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

[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

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

[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)

[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 =

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.

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"

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: Sent: Monday, December 11, 2006 3:55 PM Subject: Re:

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]>

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