Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table structure problem
Message
From
31/03/2005 15:52:39
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01000427
Message ID:
01000453
Views:
18
Hello Arto, thanks for the reply.

>
>cFields = STRTRAN(STRTRAN(FILETOSTR("MyFields.txt"),CHR(13),""),CHR(10),"")
>SELECT &cFields FROM MyTable WHERE ?myfilter
>
>
>Now you can have different field orders as far you have same fields. You just have to update MyFields.txt always when Fields are inserted or deleted or name changed. Also both have same MyFields.txt

Worth thinking about, but I would modify it so that the field listing came automatically from the table structure (eg. using AFIELDS()), rather than maintain the file manually.

Also, the above method would not be suitable for updatable views without a lot of DBSETPROP() commands to ensure the fields are updatable (unless you have any bright ideas in this area!)

Regards,
Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform