Article View: borland.public.interbase.sql
Article #667Re: Creating Strored Procedure at Runtime
From: Martijn Tonies
Date: Fri, 26 Oct 2007 12:17
Date: Fri, 26 Oct 2007 12:17
29 lines
1909 bytes
1909 bytes
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. -- Martijn Tonies Database Workbench - the IBConsole alternative! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
Technical Details
Message-ID:
<4721dac7$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!feeder3.cambrium.nl!feeder5.cambrium.nl!feed.tweaknews.nl!68.142.88.75.MISMATCH!hwmnpeer01.ams!news.highwinds-media.com!news.astraweb.com!newsrouter-eu.astraweb.com!newsfeed2.ip.tiscali.net!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4721784e@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 From: "Martijn Tonies" <m.tonies@upscene.removethis.com> Newsgroups: borland.public.interbase.sql References: <4721784e@newsgroups.borland.com> Subject: Re: Creating Strored Procedure at Runtime Date: Fri, 26 Oct 2007 14:17:26 +0200 Lines: 31 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: 212.238.159.172 Message-ID: <4721dac7$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1193401031 212.238.159.172 (26 Oct 2007 05:17:11 -0700) Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!feeder3.cambrium.nl!feeder5.cambrium.nl!feed.tweaknews.nl!68.142.88.75.MISMATCH!hwmnpeer01.ams!news.highwinds-media.com!news.astraweb.com!newsrouter-eu.astraweb.com!newsfeed2.ip.tiscali.net!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail