Thanks, that is how I understood it to be. I must be overlooking something simple here.
RBS -----Original Message----- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: 29 January 2007 23:52 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Limit statement size? RB Smissaert wrote: > Had a go at this, but sofar I haven't been able yet to get it to work. > I get no error, but A3Test115_J remains just at it is. > I couldn't find much information about INSERT OR REPLACE in the SQLite > documentation. What exactly should it do? It will try to do an INSERT. If the PATIENT_ID field is already in the file, it will delete the old conflicting entry before inserting. The best write-up is at: http://sqlite.org/lang_conflict.html HTH, Gerry ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------