Hi John
My personal preference, and which I believe to be the 'standard' is to use 'real' names for fields, like Name, Address and so on. For memory variables I always use different prefixes.
For the prefixes I try to follow the standards which I first read about in Codebook. No standard is the best standard, but it is a logical and easy to remember standard.
Some examples of my 'standards':
lcName: l for local, and c for character.
gnVat: g for global, n for numeric.
But, as mentioned above, no prefixes for field names.
>I am creating a new database should I prefix the fields with their type e.g.
>
>cName
>cAddress
>dDob
>etc
>
>or just use the field name e.g.
>
>Name
>Address
>Dob
>etc
>
>Any opinions welcome.
>
>
>Thanks.
>
>John