Questions and answers about OMNITRACKER ↦ General questions ↦ Attachments:
Set objAttachments = ActiveRequest.Userfields("Attachments").TValue
For i = 0 To objAttachments.Count - 1
Set Attachment = objAttachments(i)
Attachment.Comment = "New 123"
objAttachments(i) = Attachment
ActiveRequest.Userfields("Attachments").TValue = objAttachments
To move the attachments from the folder e.g.
I:\BE\ to a new folder e.g.
H:\ , use the following sql-statement:
SET orig_name = replace(orig_name,'I:\BE\','H:\')
WHERE link<>0 AND orig_name LIKE 'I:\BE\%';
<number>then represents the ID in the OMNITRACKER database table "Attachment". Search by:
select * from Attachment where id = <number>
ReqNo = InputBox("Please insert UniqueID:")
OpenRequest ReqNo, False, False