General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only