Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locating all instances of a field
Message
 
 
To
28/06/2016 15:41:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01637786
Message ID:
01637791
Views:
58
>It's a business system called Made2Manage that was written as one of those canned programs for manufacturing plants. So it is like divine providence, I can't change that.
>
>The field in question is Customer Number. FCUSTNO.
>
>It is in sales order tables, invoice tables, Job order tables, on and on... Many instances.
>
>I want to confirm that I have located all instances of this field in all tables.
>
>I am attempting to synch customer numbers with another division so I will have to replace all instances with the appropriate new number.

With aDBObjects() function you can get array of all table names, then you would need to use each table and check using FIELD() function, for example.

Alternative way would be to use DBC as a table and do a query against it for the field name.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform