Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building SQL structures.
Message
De
14/12/1998 14:10:55
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentine
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Building SQL structures.
Divers
Thread ID:
00167307
Message ID:
00167307
Vues:
59
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
Thanks in advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform