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

    Execute SQL Breaking on Server

    dale_allyn

      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