Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select gives me error 11
Message
From
22/01/2021 12:07:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Select gives me error 11
Miscellaneous
Thread ID:
01677886
Message ID:
01677886
Views:
99
Hello all,


Error 11 (Function argument value, type, or count is invalid)

SELECT DATE (Ann_Fisc, Periode, Jour) AS DtFisc, Mnt_PPA, Mnt_Depot;
FROM PPA_Det;
WHERE (No_Parten == PPA_Ent.No_Parten) AND (ALLTRIM (No_Facture) == ALLTRIM (PPA_Ent.No_Facture));
AND (DATE (Ann_Fisc, Periode, Jour) => THISFORM.cntPPA.txtDtPrel.Value);
AND (DATE (Ann_Fisc, Periode, Jour) > loParaPPA.dJour_Ferme);
INTO CURSOR curAjoutPPA

This gives me error 11 in my app.

When I do this in a command box

SELECT DATE (Ann_Fisc, Periode, Jour) AS DtFisc, Mnt_PPA, Mnt_Depot;
FROM PPA_Det;
WHERE (No_Parten == PPA_Ent.No_Parten) AND (ALLTRIM (No_Facture) == ALLTRIM (PPA_Ent.No_Facture));
AND (DATE (Ann_Fisc, Periode, Jour) => {^2021.03.01});
AND (DATE (Ann_Fisc, Periode, Jour) > {^2021.01.15})

Everything is fine. Any idea why I would get an error 11 only in my app?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Next
Reply
Map
View

Click here to load this message in the networking platform