execute(db.update) loses changes on form type 2
Baan: iBaanERP 5.0c
Hi, I have a basic problem which is quite simple but I just can’t get it to work.
In a form type 2. Several records have been saved. The last field on the form is a table field of type tcyesno (checkbox).
Step 1 - If the user clicks it yes, then I want the program to automatically save the changes. In the "when.field.changes" section I execute(update.db). In debug, I find that execute(update.db) resets the field value to No! This is the current table field value. Seems like execute(update.db) is actually doing a execute(recover.set)
Step 2 - then execute another function (gen.scm) to generate additional records (on the same table). This function works perfectly if the user manually "saves" the record on step 1 and then executes the function gen.scm from "specific" menu
So, in a form type 2, is user tabs past last field on form, how to auto save the record before proceeding?
Quite a simple but frustrating problem!
Thanks in advance
Better to die on your feet than live on your knees