Re: FOR operator exist

Article View: borland.public.interbase.sql

Article #899

Back to borland.public.interbase.sql Previous Next

#899

From: Thomas Steinmaurer
Date: Thu, 12 Apr 2007 18:20

35 lines
1623 bytes

Hello,

> can I do some like this
> 
> for i=1 to 100 do
> begin
>     insert into bla bla bla
> end
> 
> in SQL procedure ?
> P.S. I need to insert into table 100 records but the last value must tu 
> increase.

...
as
declare variable i integer;
begin
   i = 1;
   while (i <= 100) do
   begin
     insert into ...
     i = i + 1;
   end
end



-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com

Technical Details

Message-ID: <461e7838@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <461e72aa$2@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5eb2db7e0705274d
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 12 Apr 2007 20:20:23 +0200
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam_@upscene.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: FOR operator exist
References: <461e72aa$2@newsgroups.borland.com>
In-Reply-To: <461e72aa$2@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.56.177.91
Message-ID: <461e7838@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176401976 86.56.177.91 (12 Apr 2007 11:19:36 -0800)
Lines: 35
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message