Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query doesn't respect order of fields
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 5
Miscellaneous
Thread ID:
01229764
Message ID:
01229891
Views:
21
>Could the BROWSE LAST store the field order? I know it will keep the window size and location.
>
>
>SET DEFAULT TO "p:\visual foxpro projects"
>USE 'fortyrecs' ALIAS 'john'
>BROWSE   && shows billid, billtype, service_co, file_name
>USE
>
>SELECT service_co, billtype, billid, file_name FROM 'fortyrecs' INTO CURSOR 'john'
>BROWSE LAST
>CLOSE ALL
>
>
>It doesn't seem to store the field sequence. Not even in BROWSE FIELDS:
>
>
>CLOSE ALL
>USE fortyrecs ALIAS 'john'
>BROWSE FIELDS billid, billtype, service_co, file_name
>USE
>SELECT service_co, billtype, billid, file_name FROM fortyrecs INTO CURSOR 'john'
>BROWSE LAST
>CLOSE ALL
>
Try to manually move fields around. Do you run with SET RESOURCE ON?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform