RE: [sqlite] Updating with a Cursor

2004-04-18 Thread Chris Waters
ilto:[EMAIL PROTECTED] > Sent: Sunday, April 18, 2004 1:33 PM > To: [EMAIL PROTECTED] > Subject: RE: [sqlite] Updating with a Cursor > > > Hi, > > I am replacing a non-SQL database engine and so I'm trying to > match the existing DB API structure as closely as possible to

RE: [sqlite] Updating with a Cursor

2004-04-18 Thread Chris Waters
y, April 18, 2004 12:04 PM > To: [EMAIL PROTECTED] > Cc: Chris Waters > Subject: Re: [sqlite] Updating with a Cursor > > > On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > > > The idea is that I can iterate through a set of records with the cursor, >

Re: [sqlite] Updating with a Cursor

2004-04-18 Thread Andrew Piskorski
On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > The idea is that I can iterate through a set of records with the cursor, > updating as I go. The challenge is working out how to implement the > UpdateRow() function. I am happy to accept the costraint that the query must > Implement

Re: [sqlite] Updating with a Cursor

2004-04-18 Thread Andrew Piskorski
On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > I am building a C wrapper for sqlite that can abstract away the sqlite API Why? Are you trying to make it easier to port your application to multiple databases? If so you should look at the ns_db database API from AOLserver. It ha