Re: Arithmetic Overflow .. error 335544321 for ORDER BY

Article View: borland.public.interbase.sql

Article #880

Back to borland.public.interbase.sql Previous Next

#880

From: Adalberto Baldini
Date: Sun, 17 Jun 2007 21:07

27 lines
1881 bytes

Wayne Niddery [TeamB] wrote:
> Does it make any difference if you omit the redundant field aliases? I.e:

I did this test :
1) select a.CSOC, a.NRESERC, a.CODDOC, a.CODGIO, c.tipgio, c.DESGIO
from DOCGIO a
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  !!

2)select a.CSOC, a.NRESERC, a.CODDOC, a.CODGIO, b.tipdoc, b.DESDOC
from DOCGIO a
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 ..

I checked  Select * from DOCTIP (:CSOC,:NRESERC) and works,
I did Backup and restore of DB

Regards
Adalberto

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.euro.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46750340$1@newsgroups.borland.com> <46755fda$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
Date: Sun, 17 Jun 2007 23:07:31 +0200
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Arithmetic Overflow ..  error  335544321  for ORDER BY
References: <46750340$1@newsgroups.borland.com> <46755fda$1@newsgroups.borland.com>
In-Reply-To: <46755fda$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 84.74.35.221
Message-ID: <4675a28f$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182114447 84.74.35.221 (17 Jun 2007 14:07:27 -0700)
Lines: 27
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news2.euro.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message