E9.2 Logic Extension Update Table

[varuntl]

Hi , Is there any way in logic extension i/o operation to update an index field ? For example, I am trying to update document type column for a particular combination of doc type/doc number/doc company. (update gldct = '**' where gldct = 'AB' and gldoc = 12345 and glkco = 12345)

From what I see for update operations in logic extensions, a field can be either an index field (which is used for the select) and other fields can be used for update. Has anyone tried something like this please ?

 

[DaveWagoner]

Via LEX and ER Logic (In the beforetimes) you would need to handle this by STORING the current record in memory (variables, etc), DELETING the record containing the index you need, and then INSERTING a new record with a merge of the indexes you want and the original record. Old school!

 

[BetoJDE]

You can try with a unique index, in some ocations that works for me.