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