>>Hi Jim
>>
>>I copied the fragment below from Cetin Basoz response. Usually when I need to have updateble cursor I utilize the same approach. Does anybody know another workarround to create updateble cursor.
>>
>>select .f. as lSelected,a,b,c,.. ;
>> from mytables into cursor myCursor
>>use dbf("myCursor") in 0 again alias tcSelector
>>
>>Thanks in advance,
>>Igor Gelin, system developer
>
>Ed Pikman's approach is:
>CREATE CURSOR ...
>SELECT ... Into Array ...
>INSERT Into ... From Array
>You must be sure that array is not too big (65K limit), but you can workaround this by looping.
>
>Do you know another approach, may be using properties of the cursor?
>
>Thanks in advance
>Igor Gelin, System developer
Another approach could be a view that wouldn't update base tables. And for Ed's method instead of SQL ..into array, append from could fit well (or scan..endscan). I don't remember the original question but maybe a list is a solution too (when rowsource = alias or fields automatically move rec pointer to the appropriate record).
Cetin