Hi to all,
I've the following problem:
I must integrata a couple of tables from an external database in baan.

So I've created a dblink between the other db and baan.
Then I've produced a view on top of the external tables mapping the colum's name to baan standard (ie T$COL_NAME).
At the end I've created a synonym into the BAANDB schema for the new tables

The problems is with one of these tables (others are ok). Select on this table are always empty if I specify all the primary key, even if the record exists (select with only a part of the primary key works)
When I open a ttaad4100 on this table, I can move forward to the next record with <n> but if I press <p> I don't se the previous' one, it remains on the current record :confused: (I must press <p> two times :confused: ).

So I'm a bit confused; it seems to me (correct me if i'm wrong) that there is a problem with the primary key.
The pk of the external table is

NUMBER(22,0)
VARCHAR2(30)
VARCHAR2(20)
VARCHAR2(20)

and I've mapped it in Baan (table definition) as
tcmcs.long
tcmcs.str30
tcmcs.str20
tcmcs.str20

Any idea?

Thank you!

smallboy

Is the characterset the same between the two databases?

Dave

The two database are both oracle 8i on two windows2000 server with the same characterset and configuration.

Just a stupid question :o : I've remapped the name of the columns using baan standard (T$column_name); does baan expect a particular name also for the index1?

Yeah, it has to be in Baan format t$<column> I don't think you
can index a view so I don't think that much will matter.. but its
The index is t<table><company>$idx1

Dave