View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap