Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with Trigger
Message
De
08/09/2004 10:45:28
 
 
À
08/09/2004 10:34:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00940269
Message ID:
00940283
Vues:
15
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform