Re: [sqlite] Double quotes in C++ SQL statements

Hi Corwin, Corwin Burgess wrote: I need to know what the solution is to translate the following Delphi lines so that they will compile with C++ and be valid SQL statements. Delphi sSQL := 'INSERT INTO testtable(Name,OtherID,Number,Notes) VALUES ("Some Name",4,587.6594,"Here are some notes");';

[sqlite] Double quotes in C++ SQL statements

I need to know what the solution is to translate the following Delphi lines so that they will compile with C++ and be valid SQL statements. Delphi sSQL := 'INSERT INTO testtable(Name,OtherID,Number,Notes) VALUES ("Some Name",4,587.6594,"Here are some notes");'; sSQL := 'INSERT INTO testtable(Na

Re: [sqlite] ticket 1147

On 2/28/05, Dennis Cote <[EMAIL PROTECTED]> wrote: > Yes, it sure would be better to use an API. > > The second would naturally become sqlite3_column_table(), and the fourth > sqlite3_column_database(). > > Unfortunately, the natural name for the third item, > sqlite3_column_name(), is already us

Re: [sqlite] Trouble with column names

On Mon, 2005-04-25 at 15:12 +0300, George Ionescu wrote: > while working with sqlite v3.2.1, I've noticed another annoyance in > the way sqlite returns column names (besides the bug with #1141, > duplicated as #1218). > I have closed all these tickets now. See wiki page http://www.sqlite.org/cvst

[sqlite] sqlite3.exe timed queries

Hi - I think it would be extremely handy to have an option in the sqlite3.exe program for printing the execution time of a query. Would that be hard to add? I'm thinking something like: sqlite3> .timed sqlite3> select * from mytable; value1 value2 value3 ... Total Time: 1.253 milliseconds sqlite3

Re: [sqlite] Patches for CVSTrac?

On Tue, 2005-04-26 at 17:49 +0100, Christian Smith wrote: > Just created ticket #1224 to remove config.h from build, but there appears > to be no way to attach a patch to the ticket itself. Have I missed > something? > There is an "[Attach]" hyperlink at the top of the screen. -- D. Richard Hipp

[sqlite] Patches for CVSTrac?

Just created ticket #1224 to remove config.h from build, but there appears to be no way to attach a patch to the ticket itself. Have I missed something? Regardless, the attached patch removes config.h and related pointer macros from the source files. Pointer differences use standard pointer subtra

Re: [sqlite] Getting data into PilotSQL

Hi list, I contacted PilotSQL's author/porter to ask him about some PilotSQL internals (and also whether he planned porting SQLite3 to PalmOS), and surprisingly he sent me the full source and basically said: > I don't intend to support or maintain PilotSQL. For this reason, please > find source c

[sqlite] Test message

This is a test of the mailing list software. Please ignore. -- D. Richard Hipp <[EMAIL PROTECTED]>