Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement