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
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:
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:
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
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.
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 =
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
___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
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?
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
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 ...
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:
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
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
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,
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
30 matches
Mail list logo