Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cascade Deleteing and TABLEUPDATE ???
Message
 
To
15/04/1998 12:34:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00092168
Message ID:
00092339
Views:
27
>I looked at delete trigger code and I cannot see there a check for child tableupdate(). However usually if parent is locked it is safe enough.

I couldn't find anything in any of the books or other sources I have, that's why I was asking. I ended up doing the following and it seems to work.
DELETE
IF !TABLEUPDATE() parent table then
  =TABLEREVERT()
  display msg saying so
ELSE
  IF !TABLEUPDATE() child table
    =TABLEREVERT()
    display msg saying so
  ELSE
    thisform.cmdnext.click()
  ENDIF
ENDIF
Which seems to work ok. It's still a big mystery to me. It's something I will play around with in the evenings... (That's the joy of having computers and programming as a hobby!)
Nebraska Dept of Revenue
Previous
Reply
Map
View

Click here to load this message in the networking platform