Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sub selects in SPT
Message
 
To
20/01/2003 11:42:47
Dan Windus
Nursery Management Systems
Temecula, California, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00743498
Message ID:
00743603
Views:
11
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
Map
View

Click here to load this message in the networking platform