Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi
I have 7 offices that all use my VFP6.0 application.
On one of the views, it is doing a UNION Select statement and then ordering at the end on 2, 4.
The only problem is that on one of the offices fields 2 and 4 are different because of their position in the table.
I understand that the short-term solution is to change the view so that it orders correctly to that particular office, but I would rather know a way of avoiding this issue completely?
Anyone?
Cheers
Kev
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