Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free Tables or have Tables in a Database?
Message
From
03/01/2002 00:04:14
 
 
To
02/01/2002 20:20:57
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00600049
Message ID:
00600111
Views:
27
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform