Reported By: Donat Herbert Reported On: 10/6/2002 For: Version 3.17 Build 1
# 1238Using 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');
ResolutionFixed Problem on 10/7/2002 in version 3.18 build 1