Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sub selects in SPT
Message
 
À
20/01/2003 11:42:47
Dan Windus
Nursery Management Systems
Temecula, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00743498
Message ID:
00743603
Vues:
12
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform