Re: FOR operator exist

Article View: borland.public.interbase.sql

Article #908

Back to borland.public.interbase.sql Previous Next

#908

From: Darius Evseicikas
Date: Tue, 17 Apr 2007 05:04

57 lines
2290 bytes

Thank's for help ...


-- 
Pagarbiai
Darius Evseicikas
==================
UAB "PROGMERA"
Maironio g. 3, LT-60149, Raseiniai
tel./faks. +370 428 70329
mob. +370 699 97390
ICQ 297832308

Informacija siame pranesime gali buti konfidenciali. Ji skirta tik asmeniui, 
kuriam yra adresuota. Jei Jus nesate tas asmuo (arba atsakingas uz sio 
pranesimo pristatyma tam asmeniui), Jus negalite skaityti, kopijuoti ar bet 
kaip platinti sio pranesimo viso ar is dalies ir skleisti jame esancios 
informacijos. Jei si pranesima gavote per klaida, prasome informuoti apie 
tai siunteja ir iskart istrinti visas sio pranesimo kopijas is Jusu 
sistemos.
"Thomas Steinmaurer" <t.steinmaurer_dontbugmewithspam_@upscene.com> wrote in 
message news:461e7838@newsgroups.borland.com...
> 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: <46245516$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5eb2db7e0705274d
X-Google-Attributes: gid114a0e,public
X-Google-Language: LITHUANIAN,CP1257
From: "Darius Evseicikas" <dariuse@progmera.lt>
Newsgroups: borland.public.interbase.sql
References: <461e72aa$2@newsgroups.borland.com> <461e7838@newsgroups.borland.com>
Subject: Re: FOR operator exist
Date: Tue, 17 Apr 2007 08:04:00 +0300
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.190.34.216
Message-ID: <46245516$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176786198 213.190.34.216 (16 Apr 2007 22:03:18 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message