F_MAXDATE()

Article View: borland.public.interbase.sql

Article #743

Back to borland.public.interbase.sql Previous Next

#743

From: MrT
Date: Tue, 07 Aug 2007 18:15

18 lines
1306 bytes

Hi:

   Why would

F_MAXDATE(F_MAXDATE(m2."CRDRPT_RNW", m3."CRDRPT_RNW"),m4."CRDRPT_RNW")

Be Ok in query run through IBConsole but fail in stored procedure with 
message:

Arithmentic exception, numeric overflow or string truncation?

If I CAST(F_MAXDATE(F_MAXDATE(m2."CRDRPT_RNW", 
m3."CRDRPT_RNW"),m4."CRDRPT_RNW") AS VARCHAR(10)) in the query inIB 
Console I then get the same arithmetic overflow ....... error.

Suggestions?

Thanks.

Technical Details

Message-ID: <46b8a896$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,537ddb32d53edf11,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 07 Aug 2007 13:15:46 -0500
From: MrT <contact@heat-mi.org>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: F_MAXDATE()
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.39.70.55
Message-ID: <46b8a896$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1186506902 69.39.70.55 (7 Aug 2007 10:15:02 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1143