Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement