Alessio,
I see. You might add columns on the fly though. ie:
select *, ;
space(10) as myAddedStringColumn, ;
{/:} as myAddedDatetimeColumn ;
from myTable ;
where .f. ;
into cursor crsMyCursor readwrite
Array processing is generally faster but with these types of things it might not worth to test which one is really faster. However ALTER TABLE would have a problem. If you have longname field or add one with longname than next ... ADD COLUMN ... would error.
I suggest 'Select ... where .F. ...'.
Cetin
>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