Renaming a file

Former Member
Former Member
Hi All, I am renaming the file name in Aras through db. Below is the query for the same. After renaming the file when i am trying to open the file file is not opening as the url is not correct and its missing the vault server link. DECLARE @oldFilename varchar(100)= '2030604_DWG_Rev_AMIT KUMAR .PDF' DECLARE @newFilename varchar(100)='AMIT KUMAR .pdf' update [Innovator94_Development_DEV].[innovator].[FILE] set [FILENAME]=@newFilename,[KEYED_NAME]=@newFilename where [KEYED_NAME] = @oldFilename
Parents Reply Children
No Data