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
Former Member
Whenever you have plan for service that offers renaming and branding, you should check this one http://eatmywords.com/services/consulting/, they have best suggestions for naming everything.
Whenever you have plan for service that offers renaming and branding, you should check this one http://eatmywords.com/services/consulting/, they have best suggestions for naming everything.