Article View: borland.public.interbase.sql
Article #669Re: Creating Strored Procedure at Runtime
From: Peter Batten
Date: Sat, 27 Oct 2007 10:44
Date: Sat, 27 Oct 2007 10:44
42 lines
2338 bytes
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-mailReferences:
<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