B
Brian K. Maher
Guest
You are misreading the article. The ABL has both an ASSIGN database trigger (it’s a field level trigger) and an ASSIGN statement. In the article you link to, the code you want is this... TRIGGER PROCEDURE FOR Create OF Item. ASSIGN Item.ItemNum = NEXT-VALUE(NextItemNum). The code shown in #2 in the article simply shows how to work with sequences in your application code. Fields in a table which will get their value when a new record is created should use the TRIGGER PROCEDURE FOR Create OF code and in the trigger code you simply assign the . to NEXT-VALUE( . ASSIGN triggers (TRIGGER PROCEDURE FOR Assign of Table.Field) are used to do some processing when application code actually assigns a value to the field. Putting your code in such a trigger will not work because it won’t be executed (i.e. your ABL code, where you do the create and assign of field values, isn’t assigning anything to the sequence field. Since you are new, please note that I work in Tech Support at Progress and have about 23 years of experience in the ABL. So ... in essence ... just trust me. Brian
Continue reading...
Continue reading...