Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select gives me error 11
Message
De
23/01/2021 11:10:20
 
 
À
22/01/2021 12:18:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01677886
Message ID:
01677899
Vues:
56
Thank you for your help Tore.

>>>>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?
>>>
>>>Are you sure that THISFORM.cntPPA.txtDtPrel.Value is a date type value, and not a string that must be converted into a date?
>>
>>When I move my mouse cursor over it it displays
>>{2021.03.01}
>
>Check with Vartype(), or even better, check in the debugger. And do the same for the other values.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform