Invalid modify request conversion error from string "23/10/20022"

[Subhajit Ghosh]

Hi,
Above mentioned error is occured while generating a sql script from delphi
application.
Interbase is used as backend. Is it related to any date field type of
interbase.

Any clue will be appreciated.

TIA.

Paritosh Ganguly.

[Craig Stuntz [TeamB]]

In article <3df7...@newsgroups.borland.com>,
subhaji...@cogentech.co.in says...

> Above mentioned error is occured while generating a sql script from delphi
> application.
> Interbase is used as backend. Is it related to any date field type of
> interbase.
>

Probably. IB can't store a date this large (year 20022). Are you
sure you didn't mean 2002?

Also, if you supply dates as strings, you need to use an IB
supported format, and dd/mm/yyyy is not supported. You can use mm/dd/yyyy
however.

Or just use date params.

-Craig

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer