Hi,

just migrating another application from DBISAM: what is wrong with this code:

var
 dGebDat: TDate;
begin
 dGebDat := StrToDate('4.10.1994');
 dm.PatientenTable.Locate('Name;Vorname;GebDat',
   VarArrayOf(['Becker', 'Ulrich', dGebDat]), [loCaseInsensitive]) ;

It results in:

ElevateDB Error #1011 An error occurred with the value 34611 (A conversion error occurred)

Regards Uli

Uli,

<< It results in:

ElevateDB Error #1011 An error occurred with the value 34611 (A conversion
error occurred) >>

What does the table structure look like (including constraints and indexes,
please) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<
What does the table structure look like (including constraints and indexes,
please) ?
>>

I sent you the catalog-file by mail.

Regards Uli

Uli,

<< I sent you the catalog-file by mail. >>

If you change the TDate to TDateTime, it works.  For some reason, setting
the type of the variable to TDate makes the variant handling in Delphi think
that the variable is a Double instead of an actual TDateTime.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> If you change the TDate to TDateTime, it works.  For some reason, setting
> the type of the variable to TDate makes the variant handling in Delphi
> think that the variable is a Double instead of an actual TDateTime.

OK, thanks. Though it shouldn't have worked with DBISAM either.

Regards Uli

Uli,

<< OK, thanks. Though it shouldn't have worked with DBISAM either. >>

EDB handles variants in a Locate in a completely different manner.  DBISAM
doesn't really care due to the way that it handles the variants.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<
EDB handles variants in a Locate in a completely different manner.  DBISAM
doesn't really care due to the way that it handles the variants.
>>

Interesting - thanks.

Regards Uli