Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building SQL structures.
Message
 
À
14/12/1998 14:10:55
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentine
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00167307
Message ID:
00167310
Vues:
23
if the date variables don't already exist, and it comes up with the dialog for you to enter, you should enter the dates via ex: {12/15/1998} instead of 12/15/1998. It will consider the second version as character instead of date and cause a problem...

One other thing and I'm sure a mistype...
shouldn't the first date be >= tdDateFrom? instead of <=

>Hi all,I want to build a view rely on this SQL statement.I can create it without problems but when I execute it, shows me an error.(#incompatibility operator error).--
>
>SELECT a.date, a.concept, SUM(a.amount) AS n_impo, a.quotas ;
>  FROM Master a ;
>  WHERE BETWEEN(a.fecha,?tdDateFrom,?tdDateTo) ;
>  OR a.plan = .T. ;
>  AND a.date <= tdDateFrom ;
>  AND a.date <= tdDateTo ;
>  AND a.quotas <> "0" ;
>  ORDER BY a.date ;
>  GROUP BY a.nro_oper ;
>  INTO CURSOR c_names
>
>
>** tdDateFrom and tdDateTo are date parameters that I had defined into the view.
>What's wrong in the structure ? First ask me to input date´s statements and then the error occurs.------------
>TIA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform