Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsizing to SQL error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Database:
MS SQL Server
Miscellaneous
Thread ID:
01225443
Message ID:
01226245
Views:
17
>>Hi,
>>
>>>>I would call this a bug. But since single letter variables from a to j are not recommended, they may be excluded for field names also in the upsizing wizard.
>>>
>>>I agree with you. I also like to avoid cryptic field names. When you visit a table one year down the road you often wonder, “What is this field for”? :)
>>
>>And I agree with you <s> - but it wasn't my table. On the other hand, from the 'What is this field for' POV, the names were well chosen:
>>
>>i = Iodine
>>k = Potassium
>>p = Phosphorus
>>
>>etc....
>>Best,
>>Viv
>
>Just think - someone might have named the iodine field "53"! (Atomic Number) :)

Can't do that in VFP :-}
The originator of this table didn't stick to the chemical naming convention for all fields though - there's a field named 'sugar' rather than 'C12H22O11'.....
Previous
Reply
Map
View

Click here to load this message in the networking platform