Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Procedures and Private Datasessions
Message
 
À
20/10/1998 14:12:55
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00148402
Message ID:
00148768
Vues:
32
I think the trigger fires with INSERT INTO but you have to be careful what you are inserting. If you are setting something like a unique primary key the INSERT INTO will err because INSERT INTO has already violated the uniqueness of the field, if, it is not specified in the VALUES list or a memvar. INSERT INTO puts a null value anywhere VALUES is not specified for a field. This why I continue to generate index keys with a global routine .vs a stored procedure.

>Hmm. I was thinking field defaults...sorry. But still, it'll fire on the _buffered_ table, I do believe.
>
>>Funny, they fire when I do insert into... what use would they be if they didn't?


Eric K.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform