Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
rfromm

Member
Registered:
Posts: 32
Reply with quote  #1 
I am trying to copy Field info into an External Table then display that info in a Grid on the Form.
the code was working, but duplicating, now it has stopped working, but why? it was working yesterday.
The external table is called missingPaymentDetail, it is setup on the server in the Metastorm part of the system. The field types appear to match.
code is as follows in blue. the code is called from the user clicks onto a tick box on the form, which comes after the fields. there is nothing in the proceedure errors showing.
%ExecSQL("INSERT INTO MissingPaymentDetail (eFolderID,dtmPDate,curPVal,txtBankAccNo,txtBankSortCode,tztNextBankAccNo,txtNextBankSortCode,txtPersonPaid,txtAccountNo) VALUES ('%FolderID',%dtmPayment,%curPVal,'%txtBankAccNo','%txtBankSortCode','%txtNextBankAccNo','%txtNextBankSortCode','%txtPersonPaid','%txtAccountNo')")
I have put single quotes around the form fields that are text.
thanks
Rosemary

__________________
Rosemary
v 7.5 - still waiting for an updated version....
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #2 
Is the grid a read-only grid, and is it set to Is Dependent?  Editable grids cannot be refreshed.

Is the checkbox set to Has dependents?

Is the data getting into the table, but just not showing on the form?  Is it being populated only after leaving the checkbox field?  What happens if you did a similar action in a button?  (A button forces a form refresh, so its just a "brute force" test/question at the moment trying to fish for more information.)
0
rfromm

Member
Registered:
Posts: 32
Reply with quote  #3 
it is a read-only grid (as tried an editable one, but does not update).
It is set to be dependent on the tick box, so the plan was for the user to input into the fields on the form, tick the box to say Yes it is correct, then the field data to be copied over to the grid and displayed there.
The data is not getting to the table.
Not used a button much before, they do not have the options available do they, so it has to be scripted??


__________________
Rosemary
v 7.5 - still waiting for an updated version....
0
rfromm

Member
Registered:
Posts: 32
Reply with quote  #4 
Just tried a button with the code, it makes the form hang, then an error comes up 'Root Element is missing'. My understanding of this error is that a field is missing from the grid, but I cannoty se one is missing.
__________________
Rosemary
v 7.5 - still waiting for an updated version....
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!