Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert trigger failed error 1539
Message
 
 
À
31/10/2005 10:50:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01063588
Message ID:
01063765
Vues:
11
>Hi ,
>
>Referential Integrity Builder
>
>Error 1539 (Insert triger failed) :
>
>Parent Child Upd Del Insert ParentTag Childtag
>----------------------------------------------------------------------------------------
>Articles OrderDetail Restrict Restrict Restrict IdArt IdArt
>Order OrderDetail Restrict Cascad Restrict IdOrder IdOrder
>
>When i chenged for Insert rules (whatever, Articles or Order), Ignore instead Restrict,thats working correct.
>Where is the problem?
>
>Please, help me!

Are you sure that you're inserting right data into the child table? E.g. does the key you're inserting exist in the parent table? If not, then the message is correct, you should not allow this to happen. If your data are correct, then there was a problem in trigger's code itself.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform