🚀 go-pugleaf

In article <36C94775.33317295@skynet.be>, Luc Geers politely paraphrased 
...
> I am trying to put on a form an sql object that select the sales of the
> current day.
> It don't works with:
> 
>    this.sales = new query()
>    this.sales.parent = this
>    with (this.sales)
>       left = 2
>       top = 15.5
>       sql = "select * from sales where date=" + dtoc(date())
>       active = true
>    endwith
> 
> Is there anyone who can tell me what's wrong?
> 
DATE is a reserved SQL word, you shouldn't use it as a fieldname to avoid 
such problems.

-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--