Re: [sqlite] Closing SQLite3 from script

Kees Nuyt wrote: > > On Fri, 21 Nov 2008 12:05:51 -0800 (PST), TheOnclejuna > <[EMAIL PROTECTED]> wrote in General Discussion of > SQLite Database : > >> >>Hello to everybody, >> >>I'm working few time with SQLite, and can't solve one problem. >> >>I have a script

Re: [sqlite] sqlite3_bind_parameter_*() usage

MikeW <[EMAIL PROTECTED]> writes: > Your bind parameters VALUES (?, ?) have not been given names, > see http://www.sqlite.org/c3ref/bind_parameter_name.html > "Parameters of the form "?" without a following integer have no name and are > also referred to as "anonymous parameters"." > > ?! >

Re: [sqlite] Closing SQLite3 from script

On Fri, 21 Nov 2008 12:05:51 -0800 (PST), TheOnclejuna <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : > >Hello to everybody, > >I'm working few time with SQLite, and can't solve one problem. > >I have a script file with this commands: >

Re: [sqlite] Getting text data w/ embedded nulls from shell

On 10/21/2008 10:50, Evan Burkitt wrote: > Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote: >> >> You have the full source to the shell and can change the text printing >> routine to do whatever you want > > Yeah, I know, but that's, like, work. :) > > What I want is a tool I (and tech

[sqlite] Closing SQLite3 from script

Hello to everybody, I'm working few time with SQLite, and can't solve one problem. I have a script file with this commands: -- script.txt -- create table temp (title varchar(100), description varchar(200)); .separator ; .import ./file.txt temp update article set

Re: [sqlite] Sqlite thread safety on iPhone

Am 19.11.2008 um 17:53 schrieb Paul Clarke: > My current understanding, which may well be imperfect, is as follows: > > > > 1) If you open an Sqlite database more than once (i.e. issue > multiple calls to sqlite3_open) for reading and writing then you will > get locking conflicts between the

[sqlite] PHP created sqlite permissions

I use PDF-PDO to create and populate sqlite tables as a backup - each time the backup process is run I get a table is locked error. Deleting the sqlite db allows the process to run without error. After the db is created I chmod the file to "0775"; I notice the result is ... -rwxrwxr-x 1

[sqlite] Require Information

Hi All, I have joined recently to this userlist, I wanted to know how do I use it in SYMBIAN? is there any statistics on the amount of time taken to store/retrieve data on sqlite? regards, Deepak Dhananjaya ___ sqlite-users mailing list

Re: [sqlite] Describe [table];

Simon Davies wrote: > 2008/11/21 Arigead <[EMAIL PROTECTED]>: >> . >> . >> Question is given that "describe" isn't available, can I interrogate any >> of the system tables in order to work out what a table contains? > > http://www.sqlite.org/pragma.html > > or use "SELECT * FROM sqlite_master;"

Re: [sqlite] Describe [table];

2008/11/21 Arigead <[EMAIL PROTECTED]>: >. >. > Question is given that "describe" isn't available, can I interrogate any > of the system tables in order to work out what a table contains? http://www.sqlite.org/pragma.html or use "SELECT * FROM sqlite_master;" > > Thanks for any help Rgds,

[sqlite] Describe [table];

Hello all, just joined this mailing list to ask a question as I can't find an answer on an internet search. I'd like to create a generic utility that would allow me to pop a gui for adding a new entry to an sqlite3 database table. (I'm working in Python the moment not that that's

Re: [sqlite] Sqlite3 lock issue with NFS and read-only queries

Hi again, Actually it seems that the database file needs read-only (444) permissions for the feature to work. We did it also and I still get the same error. I am checking at the source code from Google and it's not clear enough still to know what do to :