Hello,

I'm trying to modify tdinv0510m000 (BaanIVc4) to display data from different companies.

At first I have tried it like this:

before.program:
query.extension =
"tdinv001._compnr = 006 or tdinv001._compnr = 007"

This works fine with tbase as well as with Oracle. Unfortunately I have to use it with Informix. And here the performance is absolutely unacceptable.

Then I've tried this one:

before.program:
query.extension = "tdinv001._compnr in (006, 007)"

Without the 'or' the performance is ok. But now the program does not show records from the "other" company (not the current company) unless a corresponding record exists in the current company. It seems as if a kind of 'hook' is needed to find data in the other company.

Records from the other company are indeed found when I use the butterfly button ("start set"). But not when I use the browse buttons or when I enter the search key. And this behaviour is the same with all DBs.

Any Ideas???