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

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

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

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.

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

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

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

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

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

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

"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

[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

[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

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

[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

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

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

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

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

[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