Icon View Incident Report

Serious Serious
Reported By: Donat Herbert
Reported On: 10/6/2002
For: Version 3.17 Build 1
# 1238 Using BETWEEN Operator with Tilde Character Results in Incorrect Results with ANSI Standard Tables

DBisam 3.17 Ansi Standard Language

The following SQL evaluation fails on the upper range unless that field is a KEY field. We use the tilde character to represent the high-end of the range. As soon as I made the two additional fields (EmpOrg and EmpType) both independent keys, the SQL then
evaluates correctly .. otherwise the result is no records are processed at all.

Delete from BgDLEmpb d1
Join BgSalnDL m1 on m1.Identifier = d1.Identifier
where m1.CostCentre between '!' and '~'
and m1.EmpClass between '!' and '~'
and m1.EmpOrg between '!' and '~'
and EmpType between '!' and '~'
and d1.EmployerBen in ('06','20','222');

Resolution Resolution
Fixed Problem on 10/7/2002 in version 3.18 build 1