Update
I found the problem. I have the database to check foreign key contraints on commit. The commit is where I got the error. Looks like it is working fine.
Hi All
I was doing some testing and found this in VFP8.0.
?SQLCONNECT("mydatabase") returns 1
?SQLSETPROP(1,"Transactions",2) returns 1
?SQLEXEC(1,"delete from sale where saleno = '00231'") returns 1
There is a foreign key on the sale record and a delete will fail but there is no error reported.
Smells like a bug to me. Anyone else seeing this?