General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Yeah, that's basically what I ended up doing.
Thanks,
Michelle
--------------------------------------------------------------------------------------------
>Hi!
>
>You can load all companies info into local cursor and index it. Then locating company by ID in such sursor is a single function (Lookup()) that is optimizable (and thus instantaneous with local cursor even with large number of records) and could be used as a source, for example, of grid column to display it. Only problem is downloading list af companies into separate cursor and index it at start of app or form. It could be a view as well, but just separate. You can index alias on the fly (include temp cursors and views) using INDEX command. Index file for index over the temporary resource (like cursor or view) is deleted automatically when alias closed.
>
>HTH.
Previous
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