>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.
Read after write.
Cetin