Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>
>>>I have a generic table, I know nothing about it then taht wahta I could read via VFP functions.
>>>
>>>In special:
>>>-no order
>>>-no index
>>>
>>>I need to move this into an excel spread sheet.
>>>I do this with an array to write into Excel
>>>Now the table is a bit large, so I get OLE Errors.
>>>
>>>Should not be a problem, I can write in chunks.
>>>
>>>But now I need to chunk the table
>>>Like (example)
>>>First 100 recs
>>>Next 100 recs
>>>....
>>>Last recs
>>>
>>>Is there a way to do this with VFP SQL (note: no chance for SELECT TOP, no ORDER given ...)
>>>Any other idea how to do this?
>>
>>as it is a vfp table, add a bracket to WHERE into which recno() has to be BETWEEN, and increment bracket borders in a loop
>
>
>Was there not something to not use RECNO() / RECCOUNT() in SELECT SQL? Do you think it's thrustworthy?
yes on single source-table operations
>
>It's a single cursor, it should not be a filterd SELECT SQL (What would be worst).
If it is a single cursor, why don't you build that cursor with an explicit rownum added to the end (which will force it to be physical as well) and select n-1 fields from the cursor if you really don't trust recno() of the cursor - still easy to generalize for different table structures for automatic processing, as long as source table has not max fields.
function parameters inAliasOrName, OutFile,Stepsize
and you have no problems in the future...
regards
thomas
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