Information générale
Catégorie:
Codage, syntaxe et commandes
I have a grid on a form thats based on a local view which works well. The user wants to be able use the same grid to get a view based on different parameters which would require a different kind of querry of the same underlyng data. Basically it is the exact same query with a different join type.
My thought was to create a second local view and change the data source property of the grid to the second view but when i switch to it the grid goes blank and when i toggle back to the first view the data in the grid is scrambled. Both views work when tried by hand against the data.
Is my whole approach wrong? Is there a way to programatticlay change the sql of the view to specify a different join?
TIA
Chris
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