Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field naming conventions in SQL
Message
From
11/12/2000 11:57:42
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00450333
Message ID:
00451650
Views:
27
Hi Dan.

>1) The type identifying prefix will prevent reserved-word conflicts;

True, but there are other ways to do that as well, and, in the case of SQL SELECT (which is really one of the few places where reserved words are a problem), you can use quotes around field names to eliminate conflicts.

>2) Type identifiers IMMEDIATELY identify the expected value of a column WITHOUT having to refer to the structure.

True, but IMO they also make the code a little less readable. Frankly, so does Hungarian notation for variables and properties, but in those cases, the benefits outweigh the slight drawback.

As Bruce pointed out, this is one of those religious things where I doubt one developer can change another's mind about <g>

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform