Thanks, I didn't think REPLACE would work here but you're right, it does do exactly what I need.
Best regards, Sam ----------------------------------------------------------------- We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] On Fri, Aug 22, 2008 at 3:13 AM, Francis GAYREL <[EMAIL PROTECTED]>wrote: > I met the same issue. REPLACE is the right way to override it. > Assuming C1 is the primary key or at least unique, > instead of > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users