Hello,

I have a set of Parent and child table in my Daatabse. I am using INSERT command to write to data into the databse

loop Start
Begin Transaction
Insert into Header..
if no error()
Insert into Detail..
endif
endtrans
....
.....
loop end

If I look at my tables before endtrans I can see both tables with data populated correctly. But on hiting the Endtrans statement, data in the parent table disappears and child table stays.

I have ref. integrity set in the databse. Still I am getting no error in any of the statements. and data gets writtten into the child without updating the parent.

I found that If I use SDK and repair my DBC, then it writes to both tables. But just FOXpro validate databse don't show any error.

In runtime, how will I knwo, that data is not actually, written into the parent table. I don't want child table to be updated without data in parent table. Actually, I expect some kind of error code to notify me the issue.


Thanks in advance.