Interbase and Param as DateTime

Beno?t GRIVEL

Delphi Developer

Tue, 08 Jun 2004 23:08:06 GMT

Interbase and Param as DateTime

Hi Everybody!
I've tried to port my IBX application to a DBX one, but I have a problem I
don't understand.
When I insert a statement with a param as a Date Time, I have "unassigned
code" as an error.

SQLQuery1.ParamByName('lm').AsDateTime := EncodeTime(12,12,12,12) +
EncodeDate(1998,12,12);

With IBX, no problem at all. I have to say that I don't have the problem if
I use .AsDate or .AsTime.

Do you know why?

Other Threads

1. Pb with Interbase, Null param and DateTime Param

2. Null into DateTime param not accepted

3. sql query with a param using %param%

4. Interbase and Casting a Date/Param Problem

5. Interbase DateTime string conversion?

6. About interbase's datetime

7. DateTime fields in Interbase

8. Does InterBase support DateTime?

9. Interbase, Delphi, DateTime fields

10. DateTime d1 Paradox->D5 InterBase