databound Dialog: GetValue showing value of last edited record instead of new one

[jhguru]

I have an sql-databound dialog for entering new invoices with a auto-primary key internal_invoice_no.

After entering and submitting data, the new record is inserted and can be updated afterwards - everything ok.

I have a grid component showing all invoices and a button to edit these invoices, which opens the same dialog-component, populated with the current grid records internal_invoice number - everything ok.

If I now close the two TAB-Panes and reopen the one for entering an new invoice, the dialog is empty and I can enter/submit/edit a new invoice - everything ok until here.

But, if I now use {dialog.Object}.getValue("INTERNAL_INV_NO") I get the invoice number from the last shown invoice (with the edit-button in the grid), although the new invoice number is shown correct on the dialog?

If I update another field in the invoice, the correct (last added invoice) is updated in database, but {dialog.Object}.getValue("INTERNAL_INV_NO") (and also all other fields in the dialog) show data from previous invoice.

It seems as if there is a refresh problem.

Does anyone has an idea to solve this problem? Thank you very much!

[TheSmitchell]

I have an sql-databound dialog for entering new invoices with a auto-primary key internal_invoice_no.

After entering and submitting data, the new record is inserted and can be updated afterwards - everything ok.

I have a grid component showing all invoices and a button to edit these invoices, which opens the same dialog-component, populated with the current grid records internal_invoice number - everything ok.

If I now close the two TAB-Panes and reopen the one for entering an new invoice, the dialog is empty and I can enter/submit/edit a new invoice - everything ok until here.

But, if I now use {dialog.Object}.getValue("INTERNAL_INV_NO") I get the invoice number from the last shown invoice (with the edit-button in the grid), although the new invoice number is shown correct on the dialog?

If I update another field in the invoice, the correct (last added invoice) is updated in database, but {dialog.Object}.getValue("INTERNAL_INV_NO") (and also all other fields in the dialog) show data from previous invoice.

It seems as if there is a refresh problem.

Does anyone has an idea to solve this problem? Thank you very much!

Is the button to open the dialog have "cached dialog" checked?

[jhguru]

thank your for your quick reply -no, checkbox "cached dialog" is not checked

[jhguru]

I have now migrated to Version V12, still having the same effect.

Perhaps some internal variables are not cleared after opening the dialog "with populate", so by entering an new invoice (in the empty dialog) some variable still has the old primary key value, although the new one is shown in the dialog.

Here the code which opens the dialog for exsting invoices:

var windowName = 'WINDOW_6dc55dc3_29e6_4eac_b54f_8a0c593c10bb';
var currWindow = {Grid.object}.getWindow(windowName);
var go = new Object();
go.objectId = objEle.id;
go.dialog2Name = 'RechnungDialog';
go.type = 'dialog2';
go.specialDialogMode = 'populateDialog';
go.getPKFrom = 'SpecifyNow';
go.pkValue = {Grid.object}._getValue('G','RECHNUNG',rowNum);
go.alias = '{Grid.ComponentName}_RechnungDi';
go.submitCurrentFieldValues = true;
go.sourceGridPart = 'G';
go.sourceGridRowNumber = rowNum;
go.workingMessage = '<img src=\'CSS/A5System/images/wait.gif\' />Working...';
go.placeholderValues = '';

...