Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Erik:
I thought about adding a bunch of view parameters to the existing view, but the users will be building the queries from a query form, so, what if all the parameters are not filled in? Won't it bomb?
I like the idea of building the view on the fly. I found an article in FP advisor that shows how to do so. To do this, I think I'm going to have to install my dbc's locally. Not quite sure of the implications of doing so. I always put them on the network.
Do you think it would be better to just run a query into a cursor, then make it updateable using CUSORSETPROP()? Can you duplicate the functionality of a View this way? Sounds like a better idea then screwing around with the DBC.
Thanx,
Charlie
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