Icon View Incident Report

Serious Serious
Reported By: Andrew Grilk
Reported On: 4/6/2012
For: Version 4.32 Build 1
# 3557 SQL RIGHT() Function Not Working Properly When If Number of Characters Is Less Than Argument

I have found that the right() function in SQL does not work properly.

Take a string col of width 24. Put some values in there that are say 10,11, 12 and 13 chars wideThen execute the following SQL.

This is what you get for different lengths:

10: Empty
11: Weird CTL Char followed by the 11 chars
12: 12 chars
13: 12 chars

So if you have LESS than the # of chars you want returned from the column you either get bad dad (with the CTRL char) or no data.

Select right(col, 12) from table



Resolution Resolution
Fixed Problem on 4/7/2012 in version 4.33 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image