KISTNER
2nd December 2008, 16:55
In the database A I created a view which contains some fields of the
table of the database B. In Baan the table has been created in the dictionary.
when I execute the following SQL in the Baan instance it is OK: UPDATE
table@databaseB SET descr = 'BATTERY TEST' WHERE ITEM =
'1000000001';commit; The database link has been defined.
What should we change in order to be able to write in this table through
Baan ?

Hitesh Shah
2nd December 2008, 18:11
Create separate db definition and link the same to the table u desire .

Normally complex transaction handling involving more than databases should be avoided to avoid complexities.