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
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