Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Code worked in VFP 6.0 but not VFP 8.0
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL Code worked in VFP 6.0 but not VFP 8.0
Divers
Thread ID:
00818362
Message ID:
00818362
Vues:
71
The following code, worked in VFP 8.0 but not VFP 8.0. What's up? An error message stated that a GROUP BY clause was either missing or invalid.

SELECT ;
V_POHeaderPI.Project_No, ;
V_POHeaderPI.Account_No, ;
V_POHeaderPI.PO_Main, ;
V_POHeaderPI.PO_Total, ;
V_POHeaderPI.PO_Status, ;
SUM(V_POCostsPI.cs_amount) AS nInvoiced ;
FROM V_POHeaderPI;
LEFT OUTER JOIN V_POCostsPI ON V_POHeaderPI.PO_Main = V_POCostsPI.PO_Main ;
WHERE ;
V_POHeaderPI.PO_Main = ThisForm.cPO_Main AND ;
PO_Status <> "U" ;
INTO TABLE tmpPOHeader
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform