Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field naming conventions
Message
 
 
To
19/02/2008 08:46:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01293572
Message ID:
01293902
Views:
26
>>>>You wouldn't actually call a field Name, would you?
>>>
>>>How about field name 'Field' ? :0)
>>
>>;-)
>>
>>Years ago I subcontracted on an application where purchase orders were stored in a table called ORDER. We ran into lots of issues in testing ;-)
>
>That pi**es me off outright ...
>When I see things named like reserved words and thus turning blue in my code window, I normally turn red :0)
>
>How harmfull it can really be actually doing it ? Are you aware/heard of real damages caused by this mishap ?

This was a long time ago, may have even been in FoxPro DOS. There was no colorizing of reserved words at the time. Of course we were aware that ORDER was a reserved word but it seemed like such a natural name it took us until testing to notice it. Sounds dumb but there you have it. I don't remember the exact errors, sorry. IIRC they happened in the parser, with ORDER used as a name reference and mistaken for an optional keyword.
Previous
Reply
Map
View

Click here to load this message in the networking platform