Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>>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.
As generated from the view designer:
SELECT Process.*, Machine.machdesc FROM process!process INNER JOIN maint!machine
ON Process.machnum = Machine.machnum WHERE Process.partno LIKE ?vparampn
Database maint holds table machine which is giving the trouble.
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