🚀 go-pugleaf

You can try DateValue() function in Select such as

"SELECT * FROM tblDate WHERE fldDate = DateValue(" + DateTimeToStr(dateTime)
+ ");"

or, better, use a parameter.

Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to work with MS SQL Server and MS Jet databases.


"John Larsson" <john.f.l@telia.com> �������/�������� � �������� ���������:
news:3d845d54$1@newsgroups.borland.com...
> Hello,
>
> I'm having trouble with selecting date/time from an Access database.
Access
> is storing date/time as "m/d/yyyy h:n:s ", that is without the leading
zero
> e.g. (7/9/2002 1:6:6) .
>
> When reading from a ini-file I'm getting the date/time as 2002-09-07
> 01:06:06, what I'm doing is:
>
>
>
> TDateTime dateTime = mIni->ReadString("basics", "date", DEFAULT );
>
>
>
>   String sql = "SELECT * FROM tblDate WHERE fldDate = #" +
> dateTime.FormatString("m'/'d'/'yyyy h:n:s") + "#";
>
>
>
>   ADOQuery1->Close();
>
>   ADOQuery1->Prepared = false;
>
>   ADOQuery1->SQL->Text = sql;
>
>   ADOQuery1->Prepared = true;
>
>   ADOQuery1->Open();
>
>
>
> When debugging this, the date is matching Access underlying format, but it
> will not work.
>
> The debugger is reporting:
>
> "EoleException with message, parameter-object is defined wrong. The given
> information is inconsequent or incomplete".
>
>
>
> I then created a view in Access and come up with the following:
>
>
>
> SELECT tblDate.fldDate
>
> FROM tblDate
>
> WHERE (((tblDate.fldDate)=#9/9/2002 1:6:6#));
>
>
>
> When passing that I'm getting the same error, what is wrong here?
> Thanks in advance,
> John
>
>