Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update a table in a database with a view
Message
De
05/06/2007 10:55:44
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/06/2007 08:08:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01230467
Message ID:
01230601
Vues:
12
>Cetin,
>
>Sometimes the user chooses a table with 2.8 milion address records with a lot of fields. So to make it quicker we use SQL. And to make the view more readable they can select the fields they want to see only. That's why we want to do it with a SQL view.
>
>Ron

SQL doesn't make it quicker but slower in fact. Without a view you can specify the fields you want to see.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform