RE: [sqlite] Updating with a Cursor

2004-04-18 Thread Chris Waters
[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 > mini

RE: [sqlite] Updating with a Cursor

2004-04-18 Thread Chris Waters
; 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, > > updating as I go. The

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

[sqlite] Updating with a Cursor

2004-04-18 Thread Chris Waters
Hi, I am building a C wrapper for sqlite that can abstract away the sqlite API and I am trying to work out the best way to deal with updating records using a cursor. So I want the API to look something like this when it is used: Cursor = Query("select foo from bar"); while (Cursor.MoreRecords())