[sqlite] default value in hex

2006-07-02 Thread Wilfried Mestdagh
Hi, How to specify a hexadecimal value in the default by create of a table ? I try thinks like: create table Test ( [Name] char, [Color] integer default 0xFF ); But have syntax errors. When I leave out the 0 then the xFF seems to be stored as a string. it is just that 0xFF makes mo

[sqlite] Question on reading UTF-16 files using sqlite3.exe

2006-07-02 Thread Ché Gonzalez
From my browsing through the documentation, I have observed the ability to have UTF-16 column names in sqlite3. I would like to use the command-line: sqlite3 ae.db ".read filename.sql" where filename.sql is a UTF-16 encoded file. Is there any way to do this without having to code everything in

[sqlite] PHP 5.1.4

2006-07-02 Thread David Fowler
I was wondering if anyone has the php_pdo_sqlite.dll file compiled with a more recent version of SQLite than the PHP development team have in their source tree (3.2.8) as I know SQLite is now at version 3.3.6, coming up to 10 releases ahead of PHPs rather dated inclusion. This files needed for t

[sqlite] Question on reading UTF-16 files using sqlite3.exe

2006-07-02 Thread Ché Gonzalez
From my browsing through the documentation, I have observed the ability to have UTF-16 column names in sqlite3. I would like to use the command-line: sqlite3 ae.db ".read filename.sql" where filename.sql is a UTF-16 encoded file. Is there any way to do this without having to code everything in

Re: [sqlite] BEGIN TRANSACTION appears to not lock database

2006-07-02 Thread Jan Kandziora
Am Sonntag, 2. Juli 2006 20:53 schrieb Bud Beacham: > I fixed this by enclosing RunQuery in a CATCH block. Now for another > maximum stress test. > > > #-- >--- proc RunQuery {resultDir dataBase query} {

Re: [sqlite] BEGIN TRANSACTION appears to not lock database

2006-07-02 Thread Bud Beacham
I fixed this by enclosing RunQuery in a CATCH block. Now for another maximum stress test. #- proc RunQuery {resultDir dataBase query} { set P [format "$::FW" "([lindex [info level 0] 0

Re: [sqlite] BEGIN TRANSACTION appears to not lock database

2006-07-02 Thread Derrell . Lipman
Bud Beacham <[EMAIL PROTECTED]> writes: > In the book, SQLite (version 2.x of SQLite) by Chris Newman, he writes on > page 184 that a way to test a Tcl callback function for a locked database is > to issue a BEGIN TRANSACTION in one session and run the program in another > session. Note the boo

[sqlite] BEGIN TRANSACTION appears to not lock database

2006-07-02 Thread Bud Beacham
I am developing an Tcl app on Linux with SQLite (v3.3.5), and last night I stressed tested it. Sure enough, one of process died with this error being caught, "CATCH: database is locked". In the book, SQLite (version 2.x of SQLite) by Chris Newman, he writes on page 184 that a way to test