General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Is view based on tables from separate DBCs is a bad idea in general?
>
>I don't know - I've never done it.
Hi,
a view or (a SELECT SQL) with more than one database works fine as long as you use complete naming for the table in FROM - JOIN clauses (DBCname!TableName).
SENDUPDATES will work as well.
The rules for view's properties are the same as if you have one DBC. ALLWAYS use "DBCname!TableName" for fieldnames and tables.
Finaly SET RELATION TO ,LOCATE, SEEK, SEEK() will all lead to the same result.
But this is the same as with one DBC.
For me, there is no general idea - it's by everybodys mind to use the one or the other way.
You need to find out what is fast - and what needs a minimum code to enter. ::)
Lutz
Previous
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