Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Snippets by SQL
Message
From
15/12/2014 05:23:50
 
 
To
15/12/2014 05:03:53
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01612276
Message ID:
01612295
Views:
89
This message has been marked as the solution to the initial question of the thread.
>>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
Map
View

Click here to load this message in the networking platform