Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert trigger fail
Message
 
To
06/03/1999 08:50:21
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00194828
Message ID:
00194960
Views:
18
>I have problems with two tables in my client database.Both tables have a simple One to Many relationship.When the user attempts to insert an entry in table2, it shows an error that say "Insert trigger fail".Then when I going to look for into both tables, I see that in the ID field appears the name of the Client in each table.What´s wrong with this ?.I attempted recreating al the referential integrity one more time but the problem persists.
>The insertion rule is restriction
>Please, anyone can help me?
>
>Thanks for your help

Hola Marcelo,

Check for the validation rule. For most cases, the insert trigger should be set to CASCADE.

José
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform