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

[Back to original message]