Select cause error #9999 in master-detail tables in remote session (ElevateDB 1.03 Build 1/XP SP2).
table pacients joins pregled on pac_id=pr_pac_id with foreign key
This is aquery:
on local session everything works  fine
---------
select pac_egn,pac_ime,pac_prezime,pac_familia,pr_amb_l,pr_amb_l_date
from pacients
join pregled on pac_id=pr_pac_id
where pr_amb_l_date between date '2007-03-01' and date '2007-03-31'
----------
returns 951 rows

result of the same query on remote session
================================================================================
SQL Error (ElevateDB 1.03 Build 1)
================================================================================

ElevateDB Error #9999

But with smaller range of dates works on remote session:
select pac_egn,pac_ime,pac_prezime,pac_familia,pr_amb_l,pr_amb_l_date
from pacients
join pregled on pac_id=pr_pac_id
where pr_amb_l_date between date '2007-03-01' and date '2007-03-02'
returns 67 rows without problem

Evgeni,

<< Select cause error #9999 in master-detail tables in remote session
(ElevateDB 1.03 Build 1/XP SP2).
table pacients joins pregled on pac_id=pr_pac_id with foreign key
This is aquery:
on local session everything works  fine
---------
select pac_egn,pac_ime,pac_prezime,pac_familia,pr_amb_l,pr_amb_l_date
from pacients
join pregled on pac_id=pr_pac_id
where pr_amb_l_date between date '2007-03-01' and date '2007-03-31'
----------
returns 951 rows >>

Okay, I've found the problem and a fix will be in 1.03 B2.

--
Tim Young
Elevate Software
www.elevatesoft.com