Couple problems...
First... remove the "AS" clause from your FROM statements..
From MyTable1 M1, MyTable2 M2 are both implied aliases
Second... SQL Passthrough to either Oracle, SQL or whatever has NO idea of the "?Thisform." parameterizing parts. So... prebuild a local var for these respective values and add into the SQL-Passthrough call where needed.
Now, because of your use of "?" to parameterize in case value not entered, you probably also want to validate that the given values for respective fields exist... If not, fail before even trying the call.
HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only