Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A good naming convention for fields
Message
From
08/05/2001 15:32:45
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
To
08/05/2001 03:37:26
Lowe Alan
Lowes Information Kiosks
Brisbane, Australia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00472294
Message ID:
00504957
Views:
26
>Use the suggested way in your as follows:
>
>Product.ID
>
>This way you are explicitly reference the ID field in the Product table, you can then easily search for Product.ID and the your code is easily read by others - Problem solved!

Still a problem:

1) Often I will have the same table open multiple times, each with a different alias ... for lookups, recursive relations, cursors, etc.

2) The "fields" may be SCATTERED variables ... including memvars and NAMEd objects.

3) The field names may also be "mapped" one-for-one to Form Control object names.

In every case, I still want to know "where" the Field (name) is referenced; directly or indirectly, regardless of the "container".
Previous
Reply
Map
View

Click here to load this message in the networking platform