Information générale
Catégorie:
Codage, syntaxe et commandes
Hi:
Still not deleting child records....
My code is
select gisum (parent)
replace lc_action with "D"
dele
currec= recno()
csessionkey = gisum.sessionkey
Select gidetail
if !eof()
lnDelrec= recno()
replace gidetail.lc_action with "D" while gidetail.sessionkey = csessionkey
goto lnDelrec
delete while gidetail.sessionkey = csessionkey
endif
go currec
it finds the correct sessionkey, I notice after it does replace statement it jumps to the next record or records that I'm looking to delete(i.e. if i have 2 child records I wish to delete it skips over them, so I used skip -1 to force it back and removed gotolnDelrec and still not deleting ...!
My primary key in parent(gisum) is sessionkey, this is a regular index in child
(gidetail)
Such a simple thing and I can't figure why it won't let me delete these records.
What am i missing?????
Précédent
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