Hi. I am trying to rename a section
so I am adding SQL script to the custom package
update SysModuleLcz
set Value = 'Opportunities'
where Value = 'Stands'
But upon installing it I have this error:
"Installing following SQL scripts in the database failed"
Error 42P01 "relation sysmodulealcz does not exist"
Like
Yurii,
Seems like you're using PostgreSQL DBMS, in that case your script should look like following :
update "SysModuleLcz"
set "Caption" = 'Opportunities',
where "Caption" = 'Stands'
I'd still recommend you to change the name of the section using the section wizard.
Best regards,
Yurii.
Hi Yurii,
Judging from the error message, you have a typo in your script.
Error 42P01 "relation sysmodulealcz does not exist"
in this error message it seems like you're trying to edit sysmodulealcz, whilst the actual table name is SysModule(for English localization) and SysModuleLcz(for other localizations).
Apart from that, you can simply rename the section in the section wizard and the changes will be saved in the database.
Best regards,
Yurii
Unfortunately I've made a typo here, not in the Script. So it's not that. I want references also to be renamed, that is why it is important to do it with the script
Yurii,
Seems like you're using PostgreSQL DBMS, in that case your script should look like following :
update "SysModuleLcz"
set "Caption" = 'Opportunities',
where "Caption" = 'Stands'
I'd still recommend you to change the name of the section using the section wizard.
Best regards,
Yurii.