Icon View Incident Report

Serious Serious
Reported By: Evgeni Georgiev
Reported On: 6/8/2007
For: Version 1.03 Build 1
# 2372 Executing Queries that Return Insensitive Result Sets Can Cause Error #9999

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. On local session everything works fine. Result of the same query on remote session:

SQL Error (ElevateDB 1.03 Build 1)

ElevateDB Error #9999

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'

Resolution Resolution
Fixed Problem on 6/8/2007 in version 1.04 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial