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] -----------------------------------------------------------------------------