You have many options. You can use SCAN and INSERT INTO instead of the DO WHILE loop. Even faster would be APPEND FROM...
>I use the SQL statment to select large amount of data into a cursor.
>Then I need to put those data into another Table.
>What is the most faster way ?
>My syntax is as the following :-
>----------------------------------------------
>select number AS No, amount As Amt ... From Invoice INTO CURSOR InvTable
>
>SELECT InvTable
>GO TOP
>DO WHILE .NOT. EOF()
> SELECT InvTable
> SCATTER MEMVAR MEMO
> SELECT "Transaction"
> APPEND BLANK IN "Transaction"
> GATHER MEMVAR MEMO
> SELECT InvTable
> SKIP
>ENDDO
>
>I Think That If i loop each record, It is quit time-consuming.
>Any other faster way ??
>
>Thanks.
>From Agnes