Thanks for the Information.
Had to use @formnewrecord because I have 7 files in this database. and @formCommit() to set the record.
Also I don't know if this is a problem or not, but I tried to do the same thing with Xresultsetvalue and had problems with not all of the fields posting. Using FormFieldValue all of the fields posted.
Below is a copy of the lines used for both. I can not find a reason why some fields would post and other would not. I have marked the lines that failed to post.
Pointer = @FormNewRecord("Commission_Entry") if(pointer > -1) {
// FormFieldValue(formName, name, instance,newval) formfieldvalue("Commission_Entry", "Statement_Date", Pointer, Statement_Date) formfieldvalue("Commission_Entry", "Date_Paid", Pointer, Date_Paid) formfieldvalue("Commission_Entry", "PolicyNum", Pointer, Policy_no) formfieldvalue("Commission_Entry", "Holder_Last_Name", Pointer, PHLName) formfieldvalue("Commission_Entry", "First_Name", Pointer, PHFName) formfieldvalue("Commission_Entry", "Agent_No", Pointer, Agent_No) formfieldvalue("Commission_Entry", "Agent_Name", Pointer, Agent_name) formfieldvalue("Commission_Entry", "Company0", Pointer, Company) formfieldvalue("Commission_Entry", "Due_Date", Pointer, Due_Date) formfieldvalue("Commission_Entry", "Entry_Code", Pointer, "1") formfieldvalue("Commission_Entry", "Commission_Amt", Pointer, Commission_Amt) formfieldvalue("Commission_Entry", "Commission_Note", Pointer, Note) formfieldvalue("Commission_Entry", "Issue_Date", Pointer, Issue_Date) formfieldvalue("Commission_Entry", "Type0", Pointer, Type0) formfieldvalue("Commission_Entry", "Annual_Premium", Pointer, Annual_Premium) formfieldvalue("Commission_Entry", "Mode", Pointer, Mode) formfieldvalue("Commission_Entry", "Commission_Base", Pointer, Commission_Base) formfieldvalue("Commission_Entry", "Commission_Pct", Pointer, Commission_Pct) formfieldvalue("Commission_Entry", "Mode_Percent", Pointer, Mode_Percent) formfieldvalue("Commission_Entry", "New_Due_Date", Pointer, New_Due_Date) formfieldvalue("Commission_Entry", "Plan", Pointer, Plan) FormCommit("Commission_Entry") =================================================================
did not include the "Create result set "
XResultSetCreateNewRecord(pointer) xresultsetvalue(Pointer, "Statement_Date", Statement_Date) xresultsetvalue(Pointer, "Date_Paid", Date_Paid) xresultsetvalue(Pointer, "PolicyNum", Policy_No) <<<<<<<<<<<<<< xresultsetvalue(Pointer, "Holder_Last_Name", PHLName) <<<<<<<<<<<<<< xresultsetvalue(Pointer, "First_Name", PHFName) xresultsetvalue(Pointer, "Agent_No", Agent_No) xresultsetvalue(Pointer, "Agent_Name", Agent_Name) xresultsetvalue(Pointer, "Company0", Company) <<<<<<<<<<<<< xresultsetvalue(Pointer, "Due_Date", Due_Date) xresultsetvalue(Pointer, "Entry_Code", "1") xresultsetvalue(Pointer, "Commission_Amt", Commission_Amt) <<<<<<<<<<<<< xresultsetvalue(Pointer, "Commission_Note", Note) xresultsetvalue(Pointer, "Issue_Date", Issue_Date) xresultsetvalue(Pointer, "Type0", Type0) xresultsetvalue(Pointer, "Annual_Premium", Annual_Premium) xresultsetvalue(Pointer, "Mode", Mode) xresultsetvalue(Pointer, "Commission_Base", Commission_Base) xresultsetvalue(Pointer, "Commission_Pct", Commission_Pct) <<<<<<<<<<<<< xresultsetvalue(Pointer, "Mode_Percent", Mode_Percent) xresultsetvalue(Pointer, "New_Due_Date", New_Due_Date) xresultsetvalue(Pointer, "Plan", Plan)
If anyone can see why they failed to post, please let me know.
Thanks
|