>>>>>I have a one-to-many view for which I would to give a filter for !deleted() in one table, but not the other. In the view builder (or otherwise), how do I reference one table or the other when giving a filter "deleted() = .F." ?
>>>>>
>>>>>Erik
>>>>
>>>>Try: WHERE !DELETED("Table1")
>>>>
>>>>Ed
>>>
>>>this gives "Variable 'table1' not found" (where table one is the name of my table).
>>
>>I tested it and it works fine. Can you give us the full syntax of the SQL you are using?
>
>This is probably where we are missing each other. This view was created in the view designer, and I am attempting to add the filter in the 'Filter' tab. Adding the above suggestion in the expression builder under filter gives the error.
Can you give us the SQL code up to that point?
Ed
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