Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relating Two Tables
Message
 
À
18/12/2005 20:50:27
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01077578
Message ID:
01079069
Vues:
45
>Sorry, all of that is your opinion. Record oriented xbase coding is what is so yesterday. More people dance with the SQL lady than the xbase queen.

SQL is great for transacting with DBs that require it. VFP is cleaner with XBase. Without iterative (record pointer) skills the developer cannot feed an OCX.

If you're using SQL, when you have an opportunity to use SEEK, then you're denying yourself and your users the best that VFP can offer. SELECTS require a lot of resources. They clog the work area, they clog the TEMP folder. Lets say you SELECT into a coursor then iterate the cursor to feed OCX. Look at how many steps you're going through.

There is a little project in downloads that uses seeks - only has two files - do you think it could be made to perform better by substituting SELECTS for the SEEKs?

I think performance would be seriously degraded by switching to SELECTS. It would be interesting to see a side by side.
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform