Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I have a dbc with several tables and a view. The view uses a table from a different dbc. In the past I would just add the table from the other
>>dbc to the view and everything would work fine. For some reason now, and I don't know what I did, every time I go to edit the view the
>>system can't find the external table and I have to browse for it. Any ideas on what is going wrong?
>
>Open the table's DBC
>Open the view's DBC then modify the view.
>
>Make sure the view's definition includes the database! before the table name in the FROM clause.
>
>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.
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