>>>>Note: If the table is in a different database that the table, then it doesn't matter where the table's DBC is, as long as it is open.
>>>
>>>What do I have to do with my app though? Do I have to explicitly open the other database? Just adding the table to the DE doesn't
>>>do it.
>>
>>Sorry, I made a typo - it should have been
>>" If the table is in a different database than the *view* "
>>
>>Adding the table to the DE *will* open its database. It doesn't have to be the current database, it just has to be open.
>
>That's my problem. The table is in the dbc but the app always makes me browse for the dbc as if it doesn't know
>where it is. The table in the DE has the correct path when viewed with properties.
What is the
DBGETPROP("myview","View","SQL")
?
Does the view's FROM clause have
FROM database!table
?
It should have.
Insanity: Doing the same thing over and over and expecting different results.