Icon View Incident Report

Serious Serious
Reported By: Ralf Mimoun
Reported On: 11/12/2004
For: Version 4.14 Build 1
# 1900 LEFT and REPEAT Functions Not Handling Nested Functions Properly

I just added a column to the table "Rechte". Being lazy, I wanted to generate the data from another column. That other column is called "Name", and looks like "text1.text2.text3". I want to put "text1" in the new column called "Kategorie". I used the UPDATE statement below, but nothing happens, the field "Kategorie" remains empty.

UPDATE Rechte SET Kategorie = LEFT(Name FOR POSITION('.' IN Name) - 1)



Comments Comments
The nested POSITION function was causing the issue - DBISAM was expecting a literal integer constant. The same was true for the REPEAT function.


Resolution Resolution
Fixed Problem on 11/13/2004 in version 4.15 build 1
Image