Maybe with 'suspend' inside the loop it works :)

> ------- Stored Procedure -------------
>
> declare variable TempID BigInt=0;
> declare variable F_Name VarChar(160);
> declare variable F_Word VarChar(80);
> begin
> for select DETECTID, FIRSTNAME||' '||LASTNAME,PSWORD from CONTACTS
> into :TempID,:F_Name,:F_Word
> do
> begin
> ID=:TempID;
> FNAME=:F_Name;
> PWORD=:F_Word;
> suspend;
> end
> end
>
> --
> Regards,
> Grant Brown
>
> Product Development Manager
> Phone : 02 4229 1185
> Mobile : 0412 926 995
> Email : grant@...
> Web : www.sitedoc.com.au
>
> SiteDoc - Easy to Use - Powerful Results
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>