Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which is more efficient REQUERY() or a similar SQL Pass Thru
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Which is more efficient REQUERY() or a similar SQL Pass Thru
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Firebird
Divers
Thread ID:
01260098
Message ID:
01260098
Vues:
65
Hi all

I would like to know what is more efficient, a parameterized view already populated with data and a REQUERY() is issued on it to bring in the latest changes. Or an SQL Pass Thru of the same parameters into a cursor, of course this cursor was also populated with the older data before the requirement to get the latest changes.

Please advise.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform