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

Article View: borland.public.interbase.sql

Article #11212

Back to borland.public.interbase.sql Previous Next

#11212

From: 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

Technical Details

Message-ID: <MPG.186127d2f0cf79bd98a39d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3df740bb@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,b02636cff6c70b58
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-11 08:10:16 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: Invalid modify request conversion error from string "23/10/20022"
Date: Wed, 11 Dec 2002 10:46:18 -0500
Message-ID: <MPG.186127d2f0cf79bd98a39d@newsgroups.borland.com>
References: <3df740bb@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1039621586 65.86.87.242 (11 Dec 2002 07:46:26 -0800)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message