Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with Trigger
Message
From
08/09/2004 10:45:28
 
 
To
08/09/2004 10:34:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00940269
Message ID:
00940283
Views:
14
I've chosen (I hope it's the right english verb) the afield function because
I pass some parameters to my routine to add some columns to the cursor.
Do you think is faster to exwcute an alter table after the select command or to add row to the afield Array ?


>>I'm trying to work with triggers, I call a procedure when insert, update or delete records. It seems to work fine but.... if I create a cursor as an image of a triggered table the trigger starts working even on this cursor and that is not what i want to :-).
>>I create the trigger with create cursor "cursorname" from array "arrayname" where the array is generated by the Afield fuction.
>>
>>Thank you
>>Alessio
>
>Alessio,
>1) You might set cols 13..15 to '' to avoid triggers.
>2) Instead of afields() and create ... from array you might select into cursor. ie:
>select * from myTable where .F. into cursor crsMyCursor readwrite
>Cetin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform