🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #669

Re: Creating Strored Procedure at Runtime

#669
From: Peter Batten
Date: Sat, 27 Oct 2007 10:44
42 lines
2338 bytes
Thanks Martijn,  it works correctly now.

Regards

Peter

"Jeff Overcash (TeamB)" <jeffovercash@mindspring.com> wrote in message
news:4721f7ae$1@newsgroups.borland.com...
> Martijn Tonies wrote:
> > Peter,
> >
> >> I can create many IB tables, triggers, generators, indexes, procedures
etc
> >> with run time sql calls but when I try to build the following stored
> >> procedure I get an error :-
> >>
> >> Field 'AddressAutoNo' is of an unknown type.
> >>
> >> This is originating from the first variable after the 'values'
statement
> >> ie  :AddressAutoNo
> >>
> >> If I cut the Value of quUpdateStructure.Sql ie quUpdateStructure.Sql[0]
> > and
> >> paste it into IBConsole it integrates just fine
> >>
> >> Any help greatly appreciated
> >
> > Set ParamCheck to False on the component.
> >
> >
>
> Or you can use IBScript for building DDL.  either would work.
>
> -- 
> Jeff Overcash (TeamB)
>        (Please do not email me directly unless  asked. Thank You)
> And so I patrol in the valley of the shadow of the tricolor
> I must fear evil. For I am but mortal and mortals can only die.
> Asking questions, pleading answers from the nameless
> faceless watchers that stalk the carpeted  corridors of Whitehall.
>               (Fish)
Technical Details
Message-ID: <47231665$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4721784e@newsgroups.borland.com> <4721dac7$1@newsgroups.borland.com> <4721f7ae$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,ee7bb8d1327e66d4
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Peter Batten" <datafast@tpgi.com.au>
From: "Peter Batten" <datafast@tpgi.com.au>
Newsgroups: borland.public.interbase.sql
References: <4721784e@newsgroups.borland.com> <4721dac7$1@newsgroups.borland.com> <4721f7ae$1@newsgroups.borland.com>
Subject: Re: Creating Strored Procedure at Runtime
Date: Sat, 27 Oct 2007 20:44:07 +1000
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 60.241.144.218
Message-ID: <47231665$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1193481829 60.241.144.218 (27 Oct 2007 03:43:49 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail