Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RIdelete in Stored Procedure (RI code)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
RIdelete in Stored Procedure (RI code)
Miscellaneous
Thread ID:
00531556
Message ID:
00531556
Views:
63
Hello everyone!!!!
I have a database that has 3 tables in them:
MOVE_TOB
PAID_TOB
NEWCHECK2B
They are linked like this:
   paid_tob ------->newcheck2b ------->move_tob
           paid_id               moveto_id
I genereated the RI code and it gave me these stored procedures for updating,inserting, and deleting records. I am trying to delete a record from the paid_tob table that will cascade the delete in the newcheck2b
Question:
Do I have to write my own delete routine or can I use the one that the RI code made. When I try to use the one the RI code makes, I get Errors. So What should the syntax be?

Thanks in advance
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Next
Reply
Map
View

Click here to load this message in the networking platform