>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement