Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Free Tables or have Tables in a Database?
Message
De
03/01/2002 00:04:14
 
 
À
02/01/2002 20:20:57
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00600049
Message ID:
00600111
Vues:
26
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform