UPDATE stammadresse SET NACHNAME =' bernard niekerk finall' WHERE ADRESSID = '0000000009'
UPDATE stammadresse SET NACHNAME =FB_UDF_PADLEFT('bernard niekerk finall') WHERE ADRESSID = '0000000009'
UPDATE stammadresse SET NACHNAME =ibe_PadLeft('bernard niekerk finall') WHERE ADRESSID = '0000000009'
UPDATE stammadresse SET NACHNAME =ibe_PadLeft('bernard niekerk finall',' ',40) WHERE ADRESSID = '0000000009'
I know little to nothing about Firebird, but:
According to the documentation, it support triggers (https://firebirdsql.org/refdocs/langrefupd21-ddl-trigger.html).
According to your symptoms, it looks like there is a trigger running when you perform an update operation on the table.
The trigger seems to call the FB_UDF_PADLEFT function wich does not exist anymore.
You might want to check this.
Also is not very clear what you want to update with values coming from where ?
Open in new window