Board index » delphi » Insert Date Field Error on IB 5.1

Insert Date Field Error on IB 5.1

    I have Delphi 4 update 2 with interbase 5.1 on NT 4.0 and i have the
following error :

    I can't insert the following date "23-11-1998", gives me error
conversion.

    yet if i insert "Now" this works ok.

    if i insert "12-11-1998" it works if i insert "13-11-1998" gives me an
error.

    i have the portuguese country settings, and i have dateformat  to
"dd-MM-yyy".
    in the bde it's the same : Mode=1 (DMY).

    i don't know what more can i do,

    hope someone can help me,

    TJA
    Portugal

 

Re:Insert Date Field Error on IB 5.1


Assign Dates in params of the Query.

Re:Insert Date Field Error on IB 5.1


SQL standard is "MM/DD/YYYY" regardless of you counties settings
Quote
Telmo Alves wrote in message <73ccev$6u...@forums.borland.com>...
>    I have Delphi 4 update 2 with interbase 5.1 on NT 4.0 and i have the
>following error :

>    I can't insert the following date "23-11-1998", gives me error
>conversion.

>    yet if i insert "Now" this works ok.

>    if i insert "12-11-1998" it works if i insert "13-11-1998" gives me an
>error.

>    i have the portuguese country settings, and i have dateformat  to
>"dd-MM-yyy".
>    in the bde it's the same : Mode=1 (DMY).

>    i don't know what more can i do,

>    hope someone can help me,

>    TJA
>    Portugal

Other Threads