General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only