General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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...
>
>How do you Select n-1 fields if you do not know the field names or number of fields (other then by AFIELDS()) ? Any SQL I miss? (And I miss a lot :D )
>It's just an catch-the-current-ALIAS-and-process machine. Called from everywhere. Can not alter hundreds of sources ....
either create the SQL field list once outside the loop in the method itself on the fly and call the SQL as a macro
or
use COPY TO ARRAY FIELDS EXCEPT FOR blabla syntax if you feel exceptionally lazy and are not afraid this old xBase-way will removed in the next version ;-))
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