Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An objective Analysis of RV's v. SP's
Message
 
To
24/10/2000 13:14:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00433616
Message ID:
00433701
Views:
21
>>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
Map
View

Click here to load this message in the networking platform