Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Curtis,
>It seems to me that what you're asking is how to build a logical expression that allows for completed apps, uncompleted apps and all apps. And you can't do that within the confines of the paramaterized query.
Andrew helped me see how I can do that...just not easily w/in the confines of the VD...using:
WHERE . . .
AND (Applications.lpreapp = ?vplPreapp OR .T. = ?vplAllApps)
>For speed's sake you might want to build a view or a cursor to query against, depends upon how long it takes to build that view, but I've done that before - build a base table and select from it into a cursor for the grid. Keeps things snappy and fast.
Thanks for that...
>That might also eliminate your need for indexes which can be difficult to clean up.
not sure what you mean here...I always create indexes on my listing type views that are displayed in grids, so that users can sort on various columns...how would you do that?
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