Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger failed
Message
De
13/07/2005 19:21:08
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
13/07/2005 16:21:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01032390
Message ID:
01032441
Vues:
13
>Hi,
>
>I have a following configuration in "Referencial Integrity Builder"
>
>ParentTable - ChildTable - Update  - Delete   - Insert - ParentTag - ChildTag
>Vara        - Conta      - Cascade - Restrict - Ignore - var_cod   - con_varcod
>
>
>When I try to insert data in Conta table with 0 to the field con_varcod I get the message "Trigger failed in Conta"
>
>Insert into Conta (Con_Cod, Con_VarCod, Con_Nome) values (1, 0, 'Test') && Trigger failed in Conta
>
>
>It´s bug in "Referencial Integrity Builder" ?

One bug that brought me grief in the past is that sometimes the wrong table is selected. Perhaps you have another table, whose name starts with "vara", and that happens to be open? This is a situation that should be avoided.

The debugger might help to see what is going on.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform