Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Al,
Thanks for your input.
>Are you simply displaying data (i.e. not updating?) If so I'd be inclined to use straight SELECT - SQLs. You could use a combo or radio buttons for your main choices (All, Complete, Incomplete). You can also do neat stuff like put code in your grid header .Click() so the grid resorts based on that column - lets the user view by name, application amount, date, etc. You simply supply the correct ORDER BY clause.
>
>You need to remove the grid's RecordSource before regenerating the cursor, then restore it and the columns' ControlSources each time.
Thanks...you must be reading my mind...I DO have radio buttons at the top of the form, and I DO use a grid where the user can click in the header to sort the data by various fields...but I usually use a view, creating the indexes on the view once, in the form LOAD.
And, yes, in this case, I'm not updating the view...
If using straight SELECT - SQLs, as you mentioned, I'd have to re-execute the SQL everytime the user wanted to sort on a different column? better to make a writable cursor and create all the tags once?
J
Précédent
Suivant
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