>Hi all:
>
>First, wish you all a Happy New Year and thank you all for the support I have received in the last year.
>
>Question: In developing an application, could I use Free Tables totally or should I always use a Database? Does it really matter?
>
>Thank you for your help.
>
>- Ravi
You should study the benefit of using Database.
Then, you will find that your application need those benefit or not.
But there are some situation:
across database data,
duplicate database name as different company name with similar data structure.
You need to study well what to do..
Renaming Database may cause losing most local view, remote view...
Datasbase benefit:
- allow more rules on table:
grid header displayname,
check data input
trigger handle
default value
default classlib control
- allow table relationship setting
it make table auto relate on Form DE once the table is added
- create SQL views
view can be reused many times on report.
view allow create calculated var, such as rowtotal, do report with ease.
If you create an application for single directory use,
database help you do a lot of things.
but if you need across other VFP projects and application.
You need to concern the database name to prevent duplicate.
p.s. above list is my general idea on database,
maybe there are more benefit not listed.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.