Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cascade Deleteing and TABLEUPDATE ???
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Cascade Deleteing and TABLEUPDATE ???
Miscellaneous
Thread ID:
00092168
Message ID:
00092168
Views:
60
How do you handle TABLEUPDATE when using Cascade deletion??
I have the following code which, needless to say, doesn't work
	DELETE
	IF TABLEUPDATE(0,.T.,'Property')
		* cascade delete in referential entegrity deletes persinfo records
		IF TABLEUPDATE(0,.T.,'PersInfo')
			lnRetVal = MESSAGEBOX('Property and PersInfo DELETED!',MB_ICONINFORMATION,'Property Deletion')
		ELSE
			=TABLEREVERT(.T.,'PersInfo')
			=TABLEREVERT(.F.,'Property')
			lnRetVal = MESSAGEBOX('DELETE command FAILED!',MB_ICONINFORMATION,'Property Deletion')
		ENDIF
	ENDIF
	SKIP
What do I not understand?
Nebraska Dept of Revenue
Next
Reply
Map
View

Click here to load this message in the networking platform