Article View: borland.public.interbase.sql
Article #757Re: need help with stored procedure
From: Wayne Niddery [TeamB]
Date: Tue, 26 Jun 2007 16:49
Date: Tue, 26 Jun 2007 16:49
20 lines
1685 bytes
1685 bytes
Roy wrote: > RETURNS > ( > "ATRAFFIC" FLOAT, > "GROUP_NO" FLOAT, > "MSC" VARCHAR(10) [...] > INTO : MSC,:"GROUP_NO", :aTRAFFIC; There's a space between the colon and "MSC" that might cause a problem, and you need to be consistent in case when identifiers are quoted - "aTRAFFIC" does not equal "ATRAFFIC". -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "The legitimate powers of government extend to such acts only as are injurious to others. But it does me no injury for my neighbor to say there are twenty gods, or no God. It neither picks my pocket nor breaks my leg." � Thomas Jefferson
Technical Details
Message-ID:
<46814397$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.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-mailReferences:
<4680c695@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,220d4992ac1e09be X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <4680c695@newsgroups.borland.com> Subject: Re: need help with stored procedure Date: Tue, 26 Jun 2007 12:49:26 -0400 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 69.17.170.228 Message-ID: <46814397$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1182876567 69.17.170.228 (26 Jun 2007 09:49:27 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news1.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: 1536