|
|
Posted by Beauregard T. Shagnasty on 12/05/06 20:20
Beauregard T. Shagnasty replied to hisself:
> I also tend to use non-English words for field names, which removes the
> chance that you would use a programming "key word". I would use:
>
> npart cname mdesc yprice
>
> ..with the first letter indicating the type of field, n=numeric,
> c=character, m=memo, y=currency
Actually, I would use "cpart" - a character field - instead of a numeric
field. This way you can have Part 123 and Part 123A, if necessary.
This is what I do at the motorcycle site, where the owner wanted to use
stock numbers such as "C2240", where the "C" indicates a bike being sold
on Consignment.
--
-bts
-Motorcycles defy gravity; cars just suck
Navigation:
[Reply to this message]
|