First of all, I want to say how nicely the dynamic dialog works. From a form specification table we have in our database, I have been able to build a simple form, set defaults, hide fields, make fields no entry, build comboboxes, validate data, and then add my transaction calling an SPL function in the database.
I have 2 questions. My dialog is a simple entry form,
1) What is the best way to clear the fields in the dynamic dialog? I tried a CLEAR FORM and that did not work, so I wrote a method to go through
all the fields to set them to null.
2) So we have a while loop that checks for the next dialog event. My question is, will the "BEFORE INPUT" trigger only be executed one time, so when
you first enter the while loop, after the dialog is created? I was thinking what was the best way to "start over". Maybe the user wants to start over in their input,
or you have a successful add of your data and you want to make another entry, clear the form, set defaults and start at the first entry field. Is it best to close dialog, set to null and then create it again and enter the loop, or is it fine to just clear fields, reset defaults and go to first field. I chose the latter method.
Good job with the dynamic dialog. We have wanted this feature for so long now, to build forms (simple) dynamically and capturing the input. Now, I'll try building a table, display array. :-)
Candy