Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures and Private Datasessions
Message
 
To
20/10/1998 14:12:55
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00148402
Message ID:
00148768
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform