General information
Category:
Coding, syntax & commands
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only