General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>
>>>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
Previous
Next
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