Re: Arithmetic Overflow .. error 335544321 for ORDER BY

Article View: borland.public.interbase.sql

Article #881

Back to borland.public.interbase.sql Previous Next

#881

From: Wayne Niddery [TeamB]
Date: Sun, 17 Jun 2007 23:11

23 lines
2036 bytes

Adalberto Baldini wrote:
> left join GIOTIP (a.CSOC, a.NRESERC) c on (a.CODGIO = c.CODGIO)
> where a.CSOC = :csoc and a.NRESERC =:nreserc
> ORDER BY a.CODGIO, a.CODDOC
>
> THIS WORKS  !!
>
> left join DOCTIP (a.CSOC, a.NRESERC) b on (a.CODDOC = b.CODDOC)
> where a.CSOC = :csoc and a.NRESERC =:nreserc
> ORDER BY a.CODGIO, a.CODDOC
>
> THIS DOESN'T WORK .  IT WORKS ONLY OMITTING  ORDER BY ..

Definitely seems to be an issue with joining against a stored procedure. If 
you have not put this in QC yet, please do so. Unfortunately it is going to 
be difficult to reproduce unless CodeGear folks can have your exact 
working/nonworking example db and procedures along with the above SQL 
statements.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"It used to be that other people's achievements were considered an
inspiration, not a grievance."

Technical Details

Message-ID: <4675bf85$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.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

References: <46750340$1@newsgroups.borland.com> <46755fda$1@newsgroups.borland.com> <4675a28f$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b65ddf6ccabfce00
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <46750340$1@newsgroups.borland.com> <46755fda$1@newsgroups.borland.com> <4675a28f$1@newsgroups.borland.com>
Subject: Re: Arithmetic Overflow ..  error  335544321  for ORDER BY
Date: Sun, 17 Jun 2007 19:11:02 -0400
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <4675bf85$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182121861 69.17.170.228 (17 Jun 2007 16:11:01 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.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: 1883

Reply to Parent Message