Information générale
Catégorie:
Codage, syntaxe et commandes
>>first
>I was surprised at the results. The table has about 70,000 records. But the Select SQL is noticeably slower.
as u said in another msg it is probably just the slight overhead of the
SELECT itself
>>regarding option 2 - why use an array, u can simply CREATE CURSOR and copy directly into it
>
>Needed to capture the Recno() of the records extracted from the original table. Can't do that with CREATE CURSOR because neither COPY TO nor APPEND FROM support anything but field names.
adding a single REPLACE for the RECNO() takes less code :)
Arnon
Précédent
Suivant
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