Re: [sqlite] C API Question

2006-05-05 Thread John Stanton
You seem to be looking for an sqlite3_put_table, but you will have to write it yourself. Anders Persson wrote: I have written a wrapper around iRes = sqlite3_get_table(db,sql,&resultp,&nrow,&ncolumn,&errmsg); But only SELECT works not INSERT or UPDATE any ide.. missing somting // Anders

Re: [sqlite] C API Question

2006-05-05 Thread Jay Sprenkle
On 5/5/06, Anders Persson <[EMAIL PROTECTED]> wrote: I have written a wrapper around iRes = sqlite3_get_table(db,sql,&resultp,&nrow,&ncolumn,&errmsg); But only SELECT works not INSERT or UPDATE any ide.. missing somting get table only works with select. Insert and update don't return a re

Re: [sqlite] C API Question

2006-05-05 Thread Derrell . Lipman
Anders Persson <[EMAIL PROTECTED]> writes: > I have written a wrapper around >iRes = sqlite3_get_table(db,sql,&resultp,&nrow,&ncolumn,&errmsg); > > But only SELECT works not INSERT or UPDATE > > any ide.. missing somting The database file or the directory in which it is contained is read-only

[sqlite] C API Question

2006-05-05 Thread Anders Persson
I have written a wrapper around iRes = sqlite3_get_table(db,sql,&resultp,&nrow,&ncolumn,&errmsg); But only SELECT works not INSERT or UPDATE any ide.. missing somting // Anders