This discussion is archived
13 Replies Latest reply: Nov 8, 2012 2:51 AM by user10757003 RSS

SQL in Script Question

935161 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points