Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Ulises,
>Hi all. First of all let me tell you that my application is coming out very nicely, and I must say a big thank you to all the people who has helped me here.
>Now to my next question:
>I have a form with a grid. The parent part comes from the Products table and the child (the grid) from the inventory table. I have set a relationship in both tables using CodeNumber as the common field.
>I have also set the referential integrity rules as follows:
>Parent-Update:Cascade; Parent-Delete: Ignore; Child-Insert: Restrict.
>When I set the grid to AllowAddNew=.T. and try to input a new record (APPEND, APPEND BLANK)in the grid, I got a "Trigger Failed" message BEFORE writing anything. How can a trigger fail if I haven't written any data? How to avoid this?
You've got a few possibilities:
1. Use an INSERT INTO and fill the required fields inmediatetely.
2. Set record- or tablebuffering to on and commit the insert with a TABLEUPDATE.
3. Use the defaultvalue properies of a table to put any default values in the required fields.
Personally, In your situation, I would enable tablebuffering and update with lError=TABLEUPDATE(2, .T., "yourAlias").
HTH,
Walter,
Walter,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement