[sqlite] Syntax for sql 'insert' for text with comma

Hi, I would like to insert into sometable values ( someid , text ) ; but 'text' contains a few commas, and then it would look like (...) values ( someid , text , text2 , text3 ) ; Is there a syntax to do that properly, maybe like C string constants ("text,\"text\",text\n")? Thanks, Maurício

Re: [sqlite] Are these new functions?

Thanks. There's a nice sqlite example in the homepage called "sqlite in 5 minutes or less". I think it would be nice to update it to follow the recomendations on the page you pointed me to. Best, M. > http://www.sqlite.org/releaselog/3_6_0.html > >> >> I'm having a linking problem and I

[sqlite] Are these new functions?

Hi, I'm having a linking problem and I suspect that the fault goes to the version of sqlite3 that comes with my distribution. It's 3.5.9. These functions seems to be missing: sqlite3_initialize sqlite3_next_stmt sqlite3_os_end sqlite3_os_init sqlite3_shutdown I wasn't able to find the

Re: [sqlite] Checking column constraints

ant to use that to check if an existing database was properly initialized. Maurício > Hello Mauricio, > > i do not understand your question. Perhaps you will want to rephrase it. > The table "sqlite_master" can tell you how the tables were created. See > http://www.sqlite.org/s

[sqlite] Checking column constraints

Hi, Is there any function or sql command that allows me to check which tables has a table and what are the constraints to those columns? Thanks, Maurício ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] unresolved external symbol

Hi list. I'm currently making modifications to a project, and want to add SQLite3 to it. I'm using VS6, have the sqlite3.h and sqlite3.c in the same directory, and this is the code: #include "sqlite3.h" bool TestSQLite() { sqlite3 *db; int rc; rc =

[sqlite] unresolved external symbol

Hi list. I'm currently making modifications to a project, and want to add SQLite3 to it. I'm using VS6, have the sqlite3.h and sqlite3.c in the same directory, and this is the code: #include "sqlite3.h" bool TestSQLite() { sqlite3 *db; int rc; rc =

[sqlite] How to save memory in Sqlite

Hey guys, I just ported Sqlite to my device. I want to know any feature I can turn on/off in order to save memory! I have only 2mb of disk space, so any byte is important! :) Do you guys have any tip for me? Thanks in advance, Mauricio ___ sqlite

Re: [sqlite] using sqlite3 in php

You can use the PDO extension. http://php.net/pdo http://www.php.net/manual/en/ref.pdo-sqlite.php Maurício M. Maia www.semjanelas.net jack wu wrote: apparently sqlite3 is not available in php5. i am wondering if there is anyway to work around it. i have a c++ program which works with

Re: [sqlite] Lock files....

of the optional features were always implemented as modules that could be selected at compile time (when possible of course), and everyone would be happy. Regards, Mauricio

Re: [sqlite] Script perl e python, I can't open database from sqlite

D. Richard Hipp wrote: Mauricio Piacentini wrote: I will update SQLiteBrowser to use version 3 when it leaves beta status The more people use SQLite version 3, the faster it will leave beta status Oh, ok. Good to know. I will then try to release a beta version asap, to help testing

Re: [sqlite] Script perl e python, I can't open database from sqlite

e version 3 when it leaves beta status, probably after the next release. Regards, Mauricio

Re: [sqlite] Tcl interface updated to require TCL version 8.4

file from your build. Of course you will not be able to run the TCL tests, but you can definately run your SQLite-enabled program without having TCL installed. Regards, Mauricio

Re: [sqlite] Database locked

E->IMPORT->CVS TO TABLE menu item. Give it a few minutes to insert all data, it should work. Regards, Mauricio Tabuleiro

Re: [sqlite] Dealing with 2 versions of SQLite

automatically to the new format (by doing a dump to a temp file followed by an import to a new db). Regards, Mauricio

[sqlite] ANN: SQLite Database Browser 1.1

window. This allows better support for longer records including line breaks, for example. and many other small enhancements and bug fixes. Enjoy. Regards, Mauricio Piacentini Tabuleiro

Re: [sqlite] SQLite Browser (Mac OS 10.3)

be able to benefit other users of the tool if we can find out why it does not work on your particular setup, and the problem is not related to the main SQLite library, and of little interest to other users of this list. Thanks! Regards, Mauricio

Re: [sqlite] SQLite Browser (Mac OS 10.3)

this? Regards, Mauricio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite Browser (Mac OS 10.3)

to the sqlitebrowser message boards. Regards, Mauricio Piacentini - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]