13 Replies Latest reply: Nov 8, 2012 4:51 AM by user10757003 RSS

    SQL in Script Question

    935161
      I am using the SQL below in the AftExportToDat event script, and I am receiving a data access error message(2147467259). The error log states ORA-00936 - Missing Expression.

      strSQL = "SELECT PartLastExpFile FROM tPOVPartition WHERE PartName=" & strLoc

      If I hard code the location name, then the SQL works

      strSQL = "SELECT PartLastExpFile FROM tPOVPartition WHERE PartName= 'LOC1' "

      Can anyone point out my error?
      Thanks