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);

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 result set.

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);
>
> 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?
Obviously the database file must be writable.  Also, the directory must be
writable because the journal file is created therein.

Derrell

[sqlite] C API Question

2006-05-05 Thread Anders Persson 

I have written a wrapper around
   iRes = sqlite3_get_table(db,sql);

But only SELECT works not INSERT or UPDATE

any ide.. missing somting

// Anders