![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Fri, Jun 8 2007 6:05 AM | Permanent Link |
Evgeni Georgiev | 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 Attachments: tables.zip |
Fri, Jun 8 2007 3:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |