Re: [sqlite] expression syntax

Hi NK, [EMAIL PROTECTED] wrote: Hi, what is the correct syntax to use for WHERE expression: if (sqlite3_exec(test_db, "CREATE TABLE ana_db (item1 integer, item2 integer, item3 integer, item4 integer, item5 integer);", NULL, 0, NULL)) sqlite_error(test_db); // create index if

[sqlite] expression syntax

Hi, what is the correct syntax to use for WHERE expression: if (sqlite3_exec(test_db, "CREATE TABLE ana_db (item1 integer, item2 integer, item3 integer, item4 integer, item5 integer);", NULL, 0, NULL)) sqlite_error(test_db); // create index if (sqlite3_exec(test_db, "CREATE INDEX

Re: [sqlite]

Yes, thanks to everyone who contributes to SQLite(especially DRH) ...this is an awesome piece of software and is just beautiful. :) On Mon, 17 Jan 2005 18:31:40 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > "Sqlite is finally a database product that values performance > and

[sqlite] question regarding sqliteExplorer 3.08

I'm using W2K, and I'm not sure how to config User locale to hebrew. Anyway, I rather use UTF-8, because that makes me codepage independent. It's true that when doing this, the char fields in sqliteExplorer apear &^%... (all other fields work ok) , but it's ok, my real application knows how to

RE: [sqlite] default CURRENT_TIMESTAMP status?

Indeed. Searching the source, this has never been implemented. > > Hrm. In that case, perhaps I should say "The documentation > is broken": > > [ http://www.sqlite.org/lang.html#createtable ] > > The DEFAULT constraint specifies a default value to use when > doing an INSERT. The

Re: [sqlite] default CURRENT_TIMESTAMP status?

On Tue, 18 Jan 2005, Kurt Welgehausen wrote: ... CURRENT_TIMESTAMP is broken ... I don't think it's broken; I think it's just never been implemented. Hrm. In that case, perhaps I should say "The documentation is broken": [ http://www.sqlite.org/lang.html#createtable ] The DEFAULT

RE: [sqlite] $ in table and column names

My viewpoint on this is that $ should be allowed in both table names and column names and that: CREATE TABLE ex$1( col$abc INTEGER ); Should work as-is. It does in Oracle SQL. If other languages/systems use the $ for other purposes, surely they can (or will be forced to) just avoid using the

Re: [sqlite] $ in table and column names

On Mon, 2005-01-10 at 18:00 -0500, D. Richard Hipp wrote: > A user has reported a bug saying that SQLite does > not allow the '$' in the middle of indentifiers > (without quoting). The bug reports says that > statements like this: > > CREATE TABLE ex$1( col$abc INTEGER ); > > are legal and

RE: [sqlite] question regarding sqliteExplorer 3.08

No, your USER locale must be in hebrew. Is it ? What os are you using ? Would you mind mailing me the mdb file ? Also, if you put UTF in the db, sqliteexploirer may gag. But do try it. > -Original Message- > From: Ofer Chesler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005

Re: [sqlite] default CURRENT_TIMESTAMP status?

> ... CURRENT_TIMESTAMP is broken ... I don't think it's broken; I think it's just never been implemented. > ... best way to substitute for it ... It's simple to write a trigger to do almost the same thing.

RE: [sqlite] Strange UPPER() behaviour

OK, well I guess I should be moving to version 3 soon anyway! Another reason to give to my boss... Thanks for the help. -Original Message- From: Simon Middleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 1:11 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Strange

Re: [sqlite] Strange UPPER() behaviour

Drew, Stephen wrote: Simon, Thanks for the response. Two points: 1) The code is in the SQLite library, not my application. Oh yes - so it is. And in the copy I have here (v3) it does in fact use "unsigned char *". 2) Surely if chars are signed by default in MSVC, then islower() should work with

RE: [sqlite] Strange UPPER() behaviour

Simon, Thanks for the response. Two points: 1) The code is in the SQLite library, not my application. 2) Surely if chars are signed by default in MSVC, then islower() should work with this default? PS - I have never had a problem with this before... Regards, Steve -Original

[sqlite] RE: question regarding sqliteExplorer 3.08

Hi, My System locale is already in hebrew, and the string in the sqlite apears as '?', meaning the conversion didn't go well. Currently I use only hebrew, but I might use some more languages, so I think I'm going to read it as Unicode, and use the WideCharToMultiByte function with CP_UTF8,

[sqlite] question regarding sqliteExplorer 3.08

Hi, My System locale is already in hebrew, and the string in the sqlite apears as '?', meaning the conversion didn't go well. Currently I use only hebrew, but I might use some more languages, so I think I'm going to read it as Unicode, and use the WideCharToMultiByte function with CP_UTF8,

[sqlite] Strange UPPER() behaviour

Hello, I was running my application which uses SQLite in debug mode, and I noticed some very bizarre behaviour in this function:   static void upperFunc(sqlite_func *context, int argc, const char **argv){ char *z; int i; if( argc<1 || argv[0]==0 ) return; z =

Re: [sqlite] Newbie help

yes, it is works with LccWin32 ! you have to Add all files to Project & build! Regards I. Dimitrov From: Ulrik Petersen <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] Newbie help Date: Tue, 18 Jan 2005 13:02:31 +0100 MIME-Version: 1.0

Re: [sqlite] Newbie help

Greetings Ram, Ram Kumar wrote: I am using lcc compiler for my basic learning. Is that sufficient to compile SQLite? Is there any free/openSource alternative? You will need both a compiler and a linker; I don't know lcc so I am not sure if it supplies a linker. Otherwise, here are a couple of

RE: [sqlite] question regarding sqliteExplorer 3.08

Hi. I am the author of this program. I regret to say that this version is NOT unicode-enabled, so, handling non-ascii data is a bit tricky, but possible. 1. Since any string read from the MDB (be it ansii or unicode) will be converted to ANSI (which means 8-bit characters), you can only handle

[sqlite] How to display fetched backend data?

Hi all, I fetch data from a sqlite backend database using TCL. How do I display the fetched data? For everyone's convenience, I am including my TCL code : # Loading the sqlite database load /usr/lib/tclsqlite-2.8.15.so Sqlite sqlite db1 /root/cesc_simputer.db db1 eval {select * from mri where