Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Big views
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00304695
Message ID:
00304714
Views:
25
David:

Instead of using Views try stored procedures. You can experiement with them in the Query Analyzer or Command Window. I use 4 for each table (select, insert, update, delete). In some cases you can combime them into fewer stored procedures.

You can index your cursor with 'INDEX ON SomeTable TAG SomeTag'. Also, remember you can't index a cursor with Table Buffering on, you have to switch to Row Buffering, then back to table. One of those 'Gotchas

Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform