Re: Joining a procedure

Article View: borland.public.interbase.sql

Article #611

Back to borland.public.interbase.sql Previous Next

#611

From: fusion35
Date: Thu, 16 Aug 2007 05:24

15 lines
1719 bytes

On Aug 16, 8:45 am, fusio...@gmail.com wrote:
>   select e.itemcode, e.sizeid, sum(d.monthqty*e.qty)  from saleschmst
> m
>   join saleschdet d on (d.compyrcode=m.compyrcode and d.invno=m.invno)
>   left join extractassembly(d.itemcode, d.sizeid, 'N') e on (1=1)
>   where m.compyrcode=4 and m.monthof=8 and e.itemcode is not null
>   group by e.itemcode, e.sizeid
>
> The query works in IB2007 but not in IB7.5 why?
>
> regards
>
> Devinder

gives me "convertion error from string =0" error

Technical Details

Message-ID: <1187241895.751694.300090@e9g2000prf.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!e9g2000prf.googlegroups.com!not-for-mail

References: <1187235904.825512.289670@q4g2000prc.googlegroups.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,408ede4505861ab9
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!e9g2000prf.googlegroups.com!not-for-mail
From:  fusion35@gmail.com
Newsgroups: borland.public.interbase.sql
Subject: Re: Joining a procedure
Date: Wed, 15 Aug 2007 22:24:55 -0700
Organization: http://groups.google.com
Lines: 16
Message-ID: <1187241895.751694.300090@e9g2000prf.googlegroups.com>
References: <1187235904.825512.289670@q4g2000prc.googlegroups.com>
NNTP-Posting-Host: 122.162.4.26
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1187241896 31167 127.0.0.1 (16 Aug 2007 05:24:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 16 Aug 2007 05:24:56 +0000 (UTC)
In-Reply-To: <1187235904.825512.289670@q4g2000prc.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e9g2000prf.googlegroups.com; posting-host=122.162.4.26;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0

Reply to Parent Message