>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only