>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
You can SELECT... INTO DBF XXX in the first place.
...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....
...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
Ismael Rivera "Oye cosita linda"
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only