>>I am not sure of the complete list; check the manuals. I don't have VFP at this machine. What comes to my mind now is:
>>
>>
Long field names.
>>Validation rules, for fields and records (I don't use these - I prefer triggers).
>>Referential integrity (RI).
>>Triggers. Important to update a second table with changes in a first. Triggers are used for RI.
>>Free tables can't participate in transactions.
>>Field comments - useful for documentation.
>>
>
>Thank you. No transactions is the killer. I could live without the others.
That can be quite critical, indeed. I could live without long field-names, and I don't use validation rules, even within a database. Field comments can be documented separately, if need be...
What I do consider critical is transactions, and RI. Once you start using either of them, you wouldn't want to miss it.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)