Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement