Information générale
Catégorie:
Codage, syntaxe et commandes
I guess I have spent too much time in Oracle lately! I need to do the following in a VFP database (Oracle pcode follows)
for when a user modifies a primary key in a sub table, the parent table needs it foriegn key fixed. I just seem to have gone brain dead on the VFP way to do it.
/* row level trigger of child table, fire after update */
create trigger fix_master on update of pkey row
new as new old as old
update master
set fkey = :new.pkey
where fkey = :old.pkey
I cannot figure out how to get old and new values. I have thought to do it in the form, but where is the isdirty flag, or equivilant?
Oh yeah, its not my design, or there would be no way a user could modify a primary key!
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