>>>>>
>I think it is scoped to a datasession. I had to put it in the load of my base form to work correctly.
>>>>>

SET ENGINEBEHAVIOR is a global setting.

Could you post exact SELECT statement and schemas for all tables involved?

Thanks,
Aleksey Tsingauz.