Reported By: Ralf Mimoun Reported On: 11/12/2004 For: Version 4.14 Build 1
# 1900LEFT 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)
CommentsThe nested POSITION function was causing the issue - DBISAM was expecting a literal integer constant. The same was true for the REPEAT function.
ResolutionFixed Problem on 11/13/2004 in version 4.15 build 1