[sqlite] Detect nullable fields?

Hi, is there a function to detect nullable fields? Thanks Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users

[sqlite] Foreign key support

ing | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Encryption and decryption functionality ?

Hi, I have got any information that sqlite supports encryption and decryption. Does it ? If these are extensions, where to get ? Alternative variants available ? Thanks Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2

Re: [sqlite] Database locking issue

are welcome. Thanks, Lothar Am 19.09.2008 um 17:37 schrieb Lothar Behrens: > > Am 19.09.2008 um 17:03 schrieb Ken: > >> Try it with the latest full build say version 3.6.2 and see what >> happens instead of a "patched" >> > > I'll give that a try. Could

Re: [sqlite] Database locking issue

the opposite stuff in the actual code) Lothar > -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

[sqlite] Database locking issue

Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Closing database fails due to unfinalized statements

Am 16.09.2008 um 16:51 schrieb Dan: > > On Sep 16, 2008, at 4:44 PM, Lothar Behrens wrote: > >> Hi, >> >> I do have any unfinalized statements in my application when compiled >> on Windows, but not on Mac OS X. >> >> Is there any difference I am

Re: [sqlite] Closing database fails due to unfinalized statements

Yes, that's what I expected, since my debugging attempts into my sqlite library version always failed. And it makes it clear why there are these differences. Thanks Lothar Am 16.09.2008 um 17:00 schrieb Jay A. Kreibich: > On Tue, Sep 16, 2008 at 11:44:24AM +0200, Lothar Behrens scratc

[sqlite] Closing database fails due to unfinalized statements

differences in my compiler switches (defines). Thanks Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Insert statement is ok but after reopening the db data is missing ?

Am 10.09.2008 um 17:37 schrieb Dennis Cote: > Lothar Behrens wrote: >> What is the function to rollback a transaction or commit ? >> I want also to break into these functions. If there is no way I try >> to implement the rollback and commit callbacks. >> Also the cl

Re: [sqlite] Insert statement is ok but after reopening the db data is missing ?

Am 09.09.2008 um 22:49 schrieb Dennis Cote: > Lothar Behrens wrote: >> >> But when you say, that, if jornal files are open, transactions are >> opened, I would set a >> breakpoint at the line of code the transaction opens these jornal >> file >> an

Re: [sqlite] Insert statement is ok but after reopening the db data is missing ?

Am 09.09.2008 um 20:46 schrieb Dennis Cote: > Lothar Behrens wrote: >> >> I have added this function right after sqlite3_step, that does the >> prepared insert statement. >> >> int nReturn = sqlite3_step((sqlite3_stmt*)(*start)); >> >>

[sqlite] Fwd: Insert statement is ok but after reopening the db data is missing ?

opened. Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Insert statement is ok but after reopening the db data is missing ?

y first row -> no jornal file is opened, because no write is yet done. Adding some rows and navigating forward and backbackward -> jornal file is opened and I can see my data in the application. Now I will try to use pragma database_list; but I need to restart my box. So I will m

[sqlite] Insert statement is ok but after reopening the db data is missing ?

? (After the insert statement until to closing of that file) Thanks in advance, Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

07.09.2008 um 20:17 schrieb John Stanton: > 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 followin

Re: [sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

finalize() your statement or sqlite3_reset() ist to > execute it > again, perhaps with other bind variable values. > > Martin > > Lothar Behrens wrote: >> Hi, >> >> I am struggling with the following situation: >> >> I have a table where two rows are ins

[sqlite] Urgent: sqlite3_step and SQLITE_DONE ?

+ 'have the last row now' ? Thanks Lothar -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de Lothar Behrens Heinrich-Scheufelen-Platz 2 73252 Lenningen ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Locked database problem

Hi, I have s question about avoiding locked database errors by closing a connection in these circumstances. In my test application this works and I also can see that the related data has been inserted. But in my main application I also close the connection without success. Is it possible,

Re: [sqlite] CASE WHEN sample ?

Am 11.05.2008 um 22:25 schrieb Igor Tandetnik: > "Lothar Behrens" > <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> Unique index and using replace into ... changes the primary key value, >> what I cannot handle yet, because I am using trigger

Re: [sqlite] CASE WHEN sample ?

, is this then correct ? INSERT INTO "Application" (id, name) SELECT id, 'lbDMF Manager' from "Application" where id not in (SELECT id from "Application") It works syntactically (in sqliteman) but has no effect. Thanks Lothar > Woody > from his pda > > ---

[sqlite] CASE WHEN sample ?

Hi, I am searching for a sample that uses the case when expression. I like to insert values into a table when these values are not in that table before. My tries to read, understand and try the documentation of expressions failed. Executing this statemen twice creates two rows: replace into

[sqlite] Simpler samples as FTS ?

documents out describing that at a howto level (not API level docs) ? Thanks, Lothar -- Lothar Behrens | Rapid Prototyping ... Heinrich-Scheufelen-Platz 2 | 73252 Lenningen | www.lollisoft.de

Re: [sqlite] Foreign keys

) c[_] --- -- To unsubscribe, send email to [EMAIL PROTECTED] --- -- -- Lothar Behrens | Rapid Prototyping ... Heinrich-Scheufelen-Platz 2 | 73252 Lennin

Re: [sqlite] Foreign keys

Am 29.12.2007 um 13:59 schrieb Kees Nuyt: Hi Lothar, On Sat, 29 Dec 2007 13:13:04 +0100, Lothar Behrens <[EMAIL PROTECTED]> wrote: The only implementation I'm aware of is the one using triggers, but the creation is not implemented as an extension. http://www.sqlite.org/cvstrac/

[sqlite] Foreign keys

such an implementation that could be reused ? (public domain or LGPL is preferred) Thanks, Lothar -- Lothar Behrens | Rapid Prototyping ... Heinrich-Scheufelen-Platz 2 | 73252 Lenningen | www.lollisoft.de

[sqlite] Foreign keys ?

in some 'system tables' (DROP TABLE could remove these informations again) ? Then the API could be extended by looking in these tables for foreign keys, what would be reasonably fast. Thanks, Lothar -- Lothar Behrens | Rapid Prototyping ... Heinrich-Scheufelen-Platz