Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field naming conventions in SQL
Message
From
07/12/2000 15:34:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00450333
Message ID:
00450572
Views:
43
I agree completely - field type-naming conventions has saved me a ton of time.

>This subject looks like an ideal candidate for a survey:
>Q 1: Which of the following do you think should include a letter indicating data type:
> - Variable names.
> - Properties.
> - Field Names.

All three.
Variables should also include scope - "lc" for "local character", e.g.

I hold to a functional naming convention for field names - e.g., in VFP, we would have a logical field, ergo use lField. In SQL Server and Oracle, there is no logical field. You must some other type of field - I've seen numeric and character in both and bit and tinyint in SQL Server. I prefer bit in SS and number(1,0) in Oracle. However, I still use lField for the name. This is a stretch for some, but w/in a system, the convention would be known that "we use tinyint for logical fields", or "we use char(1) with 'Y' and 'N' for logical fields."

>Q 2: How many years experience do you have? This would be good if it could show how much of the experience was associated with looking after either legacy systems or systems written by someone else. Developers who are forever working on green field (AKA blue sky) projects, and never get involved in supporting those systems have opinions (in my opinion) that are borderline worthless.

6 years - not as much as some, but all in large scale, complex applications using VFP, SS and/or Oracle
Also, it's all been in team development environments, another good reason for naming conventions.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform