>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"
Précédent
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