Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
If I have a parent/child relationship established and the parent table is filtered via set filter to . . . .
I want to use SQL SELECT to create a cursor from both tables containing only the records that are consistant with the filter established in the parent table, the following code seems to work . . .
lcFilter = filter()
SELECT FROM etc etc
WHERE &lcFilter ;
etc etc
There are however 2 problems. The first of these is that if the filter condition references a field that is contained in both tables, such as the join field, it will crash. Prefacing the field with the alias when the original filter is created corrects this but getting my user to do this will be difficult.
The second problem is that the SELECT statement behaves as if SET EXACT is OFF even though the actual setting is ON. Does anyone know of a way to deal with these two situations?
Thanks in advance for any insights.
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