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

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Subhajit Ghosh Wed, 11 Dec 2002 13:42

#11209

Author: Subhajit Ghosh
Date: Wed, 11 Dec 2002 13:42

11 lines
1291 bytes

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.

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

#11212

Author: Craig Stuntz TeamB
Date: Wed, 11 Dec 2002 15:46

23 lines
1790 bytes

In article <3df740bb@newsgroups.borland.com>, 
subhajit.ghosh@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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads