Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
An objective Analysis of RV's v. SP's
Message
 
À
24/10/2000 13:14:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00433616
Message ID:
00433701
Vues:
24
>>I just thought I'd point out a scenario where using RV's would mean less >>modification if the user wishes to change the sort/filter/fieldlist criteria >>in the app than a stored procedure (which would require the modification of >>the actual SP on the back-end).

Using Views you would have to drop the view from the DBC, rebuild it, then add it back. Also, you got to close the tables in the DE and reopen them. Thats a lot of overhead! Using the SP approach, you can build the SQL string on the fly based on user defined criteria then pass into the SP. From there you use the exec() function to evaluate and run it. Or, just go with straight SPT. Either way, you don't modify the SP.

Charlie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform