SQL selecting on date

Article View: borland.public.vdbase.forms

Article #349

Back to borland.public.vdbase.forms Previous Next

#349

From: Luc Geers
Date: Tue, 16 Feb 1999 00:00

23 lines
1095 bytes

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?

Thanks !

Luc

---------------------------------------------------
  Website 't Vosje: http://users.skynet.be/tvosje
     Omnisportclub voor mentaal gehandicapten     
---------------------------------------------------

Technical Details

Message-ID: <36C94775.33317295@skynet.be>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 15bdfb,5ea149ed5131c381,start
X-Google-Attributes: gid15bdfb,public
From: Luc Geers <luc.geers@skynet.be>
Subject: SQL selecting on date
Date: 1999/02/16
Message-ID: <36C94775.33317295@skynet.be>
X-Deja-AN: 444894378
Content-Transfer-Encoding: 7bit
X-Accept-Language: nl
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.forms