Article View: borland.public.interbase.sql
Article #1017Re: Pls help with procedure
From: Loren Szendre
Date: Fri, 09 Mar 2007 10:50
Date: Fri, 09 Mar 2007 10:50
10 lines
1253 bytes
1253 bytes
Darius, One idea I had was to create a view so that your "Extract" columns have normal names. Then in your stored procedure you could group by the "new" names, and it should all work. I believe Firebird supports what you were trying to do. But the above should work with IB. Loren
Technical Details
Message-ID:
<45f13497$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<45f12ed6@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,90802e9148f8740b X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Fri, 09 Mar 2007 02:50:18 -0800 From: Loren Szendre <zorenlendry@yahoo.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: Pls help with procedure References: <45f12ed6@newsgroups.borland.com> In-Reply-To: <45f12ed6@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 64.185.115.67 Message-ID: <45f13497$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1173435543 64.185.115.67 (9 Mar 2007 02:19:03 -0800) Lines: 10 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail