Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating SQL structures
Message
De
15/12/1998 05:50:09
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentine
 
 
À
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Creating SQL structures
Divers
Thread ID:
00167573
Message ID:
00167573
Vues:
59
Hi Nancy,I need your help

I have this SQL statement.I want that tdDateTo(in the AND statement) takes the value of tdDateTo(of the BETWEEN statement).I did try with
{tdDateTo} in the AND statement but the field appears like this{/ /},and not shows the wanted values.
What's wrong in the structure ?
SELECT a.date, a.concept, SUM(a.amount) AS n_impo, a.quotas ;
  FROM Master a ; 
  WHERE BETWEEN(a.date,tdDateFrom,tdDateTo) ;
  OR a.plan = .T. ;   
  AND a.date <= {tdDateTo} ; ---->>>> this 
  AND ALLT(a.quotas) <> "0" ;
  ORDER BY a.date ;
  GROUP BY a.nro_oper ;
  INTO CURSOR c_names
TIA.
Thanks in advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform