> >
> >
> > That would in my coding style not be sal_empid. It would be Sal.empid where Sal would be a table alias for Salaries or some such table name.
> >
> > The column names should IMO not be prefixed with som abbereviated table name. If a table reference id needed for clarity, it's easily added by using Tablealias.columnname
> >
> > I don't use a data type prefix either even though that's recommended in VFP's documentation, and is a fairly widespread custom in the Xbase world.
>
> Yes. I've used them and not used them over the years. But since learning to use the table prefix in the field names, I've grown to like it.
>
> Mike Yearwood
>
>
>

i picked up the idea of short table prefixes to table names while working with George Goley at MicroEndeavors and i too have grown to like it. orderno in Orders would be o_orders, i_orderno in Items and r_orderno in Releases. there is consistency in that orderno is in all field names having the same purpose or meaning.

i do preface field names with their table names in the code but, because these fields are unique, omit table name references from the fields in queries constructed on-the-fly from the command window. i suppose this is as many other things really a matter of personal preference.

Garth Groft