Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need cascading inserts!
Message
From
07/01/1997 09:04:06
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00016574
Message ID:
00016644
Views:
73
>>You can open Parent Table Properties (in Table Designer) and put your custom stored procedure name into Insert Trigger Box. Then you open Stored Procedure editor and write your custom code (under this procedure name) to insert values into appropriate tables (I guess it should be some UPDATE_SQL commands). It's a good idea to have some customized error messages when you return .F. from trigger.
>
>Thanks Edward.
>
>Now in my referential integrity builder should I ignore or restrict my insert? As far as my experience goes it's slim, so bare with me.

You should 'Ignore' in RI builder.

Using the UPDATE_SQL command how should I go about appending blanks to the tables? I don't have much experience using SQL.

Use INSERT-SQL for appending records with pre-defined values (it's much better than using blank records).
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform