>i used to make projects with several tables all in one database. regularly i would have problems with validation of databases for various reasons. it was solvable but my intervention was always necessary.
>
>recently i made a project using free tables instead of putting all into the database.
>
>i found no change in speed or the way i programed or in the way i used my SQL commnands.
>
>so my question is what is my advantage of using the database in the first place (other than being able to use more than 10 characters as a table name).
>
>i found using free tables a lot easier with more peace of mind.
Referential integrity is the most important argument.
Apart from the arguments presented by Terry, a free table can't participate in transactions.
Also: I find it very useful to have field comments. This is not possible with free tables. With comments, the documentation is included in the database structure itself, which is very useful.
Grüsse,
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)