Re: [sqlite] Field name

2003-11-28 Thread D. Richard Hipp
Bronislav Klučka wrote: So there is nothing like C escape strings? (\", \',\\,etc.) And the way to do it is to leave the field name, column name or string the way it is, close it into double quotes and duplicate all double quotes in the identificator? Correct. That is what the SQL standard

[sqlite] API functions description

2003-11-28 Thread Bronislav Klučka
Hi are there any web pages which describe the SQLite API functions? The page on offitial site is not complete... Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] New expresion

2003-11-28 Thread Bronislav Klučka
Hi, is there some way how to do new statement? I want to create ALTER TABLE statement... I know that I can do it using temporary table, but I'm looking for another way... Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [sqlite] Command-line SQLite

2003-11-28 Thread Paul Smith
At 15:20 28/11/2003, [EMAIL PROTECTED] wrote: I'm attempting to use the command-line SQLite to test the speed of certain "selects" and how writing them in different fashions affects speed OK, can anyone explain (no pun intended!) what I should be looking for in what information "explain"