Re: passing date parameter in commandtext

From: David (dfm_at_cmgasia.com.hk)
Date: 12/24/03 

Date: Wed, 24 Dec 2003 11:39:29 +0800

SamiraInStL <samirastl@earthlink.net> wrote in message
news:3fe90a18$1@newsgroups.borland.com...
> datas is from Access 2000 and it shows the whole table in my DBGrid.
> I enter 2 date string in Edit1 and Edit2 control.
>
> How do I pass the date parameter to commandtext in AdoDataset ?
>
> adodataset.commandtext := 'select id, PayDate from tblPayment where
payDate
> >= ' + edit1.text + 'and payDate <=' + edit2.text ; // this does not work
>
> Please help
> somner
>
>
I am not familiar with Access, but the other SQLs I use require that the
date be in mm/dd/yyyy format. Is edit1.text and exit2.text in that format?

David