Marcelo,

The ? represents that what follows it is a parameter variable and is needed. You get asked for dDateTo twice because it is encountered twice in the SQL.

>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

Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.