I have a PK set for social security numbers in one table. I frequently replace data in that table from a fresh CSV file. I use "GATEWAY IMPORT CSV filename.csv REPLACE tablename." The process stops dead in its tracks displaying "Values for tablename must be unique," even though there are no duplicates.
When I delete all the rows myself, before I run the GATEWAY command, all the new rows load successfully with no errors. It's that word REPLACE that has me wondering. It's as though some old rows are lingering behind and causing duplicates. I have a wild imagination. Fred Fred C. Kopp Authorized R:Base Developer 19 Teri Lane Washington, PA 15301 P 724-222-7376 F 724-222-7376 C 724-413-5534 E [EMAIL PROTECTED]
