Hi Folks another probably dumb question but not sure where to take it next?
I have a form where onShow() I do this
var recToUse = databaseManager.getDataSetByQuery(globals.vServerToUse,'Select fc_id from fabric_condition WHERE cd_id = '+globals.comp_id, null,1)
forms.fabman_frm_detail.foundset.selectRecord(recToUse.getValue(1,1))
The code sets the current record to sync with another table (where we dont want to use a relation)
Unfortunately when I do then setAutoSave(false) does not work - whether it is set prior to this code or after it.
What happens is that any editing done on that form is auto saved to the db and my trapping code see’s it as saved, so this code returns false;
application.output(databaseManager.hasRecordChanges(forms[event.getFormName()].foundset,1))
If I comment out the “forms.fabman_frm_detail.foundset.selectRecord(recToUse.getValue(1,1))” the form behaves as expected.
Doubtless this is a challenge with the way I implement this selectRecord() but;
Q. Why would this code cause the form to autosave, and
Q. How can I use this type of record selection and still have the form autoSave(false)??
Appreciate Feedback.
EDITED: Looks like I had overlooked the possibility that the global may be null AAArrhh… Thanks for looking!