DQL statement to updating reapiting field

dddd

Hi Guys,

How do I update the i_folder_id with newly created one ?

Thanks in advacnce.

Kind Regards,

Thomas

Find more posts tagged with

Comments

bacham2

You don't update the field directly. You have to use the LINK/UNLINK keywords in your DQL update statement.

e.g. UPDATE dm_document objects UNLINK '/Temp' LINK '/mycabinet/myfolder' WHERE ...

msroth

Bacham2 is right, you should use the LINK/UNLINK DQL commands. However, if you want to manipulate repeating attributes in DQL you can. DQL allows you to insert, append, remove, set and trucate repeating attributes. For example:

UPDATE dm_document OBJECTS APPEND authors = 'Scott' where ...;

UPDATE dm_document OBJECTS REMOVE authors[1] where ...;

UPDATE dm_document OBJECTS INSERT authors[0] = 'Scott' where ...;

UPDATE dm_document OBJECTS SET authors[0] = 'Brian' where ...;

UPDATE dm_document OBJECTS TRUNCATE authors[0] where ...;