Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building SQL structures.
Message
From
14/12/1998 14:10:55
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Building SQL structures.
Miscellaneous
Thread ID:
00167307
Message ID:
00167307
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform