General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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