Hi Frank,
I have this SQL statement.I create it by the View Designer.The question is why when I execute the view,it asks me twice the dDateTo parameter? I need that dDateTo statement takes the value of the BETWEEN's dDateTo value by default.I know that is simple but it doesn´t works.I´ve defined both parameters into the view parameters.
I´ve just tried to put it without "?" but the View Designer puts automatically quotation marks on it.
What´s wrong with this? or...with me
Thanks in advance for your response.
SELECT MyTable.date, MyTable.descrip, SUM(MyTable.amount), MyTable.quotas,;
FROM MyDatabase!MyTable;
WHERE MyTable.date BETWEEN ?dDateFrom AND ?dDateTo;
OR (MyTable.plan = .T.;
AND MyTable.date <= ?dDateTo;
AND ALLT(MyTable.quotas) = "0");
GROUP BY MyTable.oper_num;
ORDER BY MyTable.date
TIA
Thanks in advance