Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating SQL structures
Message
From
15/12/1998 05:50:09
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
 
 
To
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Creating SQL structures
Miscellaneous
Thread ID:
00167573
Message ID:
00167573
Views:
54
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
Next
Reply
Map
View

Click here to load this message in the networking platform