Dear all I wonder if you could help.
Im using the visual foxpro ODBC driver and sql passthrough commands
I have a table setup with a primary key of say ref.
After adding a record to a table and then deleting it using the following
sqlexec(nconnection,"DELETE from tablename where ref='x'")
followed by a tableupdate(.t.)
the record disappears.
but when i try to add another record with the same ref it comes up with a
'index key violated error' which tells me it hasnt actually deleted the
If i do exactly the same thing but use the microsoft SQL 7 it works fine?
Can you help???