1 2 Previous Next 20 Replies Latest reply on Jul 16, 2017 9:07 AM by dale_allyn

    Execute SQL Breaking on Server


      Host: FMS 16.x

      Clients: FMP 15


      Data input layout allows a person to "sign-off" on an analysis (two persons required). Signatory 1, and Signatory 2, confirm data within the record.


      Once each confirms the data,  a field is to be populated with their formal signatory title (based on user account record in a user table). 


      A report is generated and their titles/qualifications are presented in the appropriate place below where they will sign.


      This works great locally, but on the server it does not. The Report_details field is not updated with the technician on the server, but it is on a local file. I'm not married to SQL, so happy to do anything that will insert the formal title when a tech signs-off (a check box).


      Here's the query that works locally, but not hosted:


      ExecuteSQL ("

        SELECT UserList.gemlgstReportName FROM UserList WHERE UserList.FMPacctName = ?";"";""; Report_Details::gemmologist_1



      Thank you for putting your eyes on this.

        1 2 Previous Next