Svein Erling Tysvær skriver:
>
> You could try something like (not tested):
>
> EXECUTE BLOCK AS
> DECLARE VARIABLE MyDbKey char(8);
> BEGIN
> for select LrgTbl.rdb$db_key
> from "LargeTable" LrgTbl
> inner join "Uppgiftshållare" UH on UH."ECO_ID" = LrgTbl."Hållare"
> inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = UH."Hanterare"
> where LrgTbl."ÄrNull" = 0
> and UH."Propertynamn" in ('This', 'That', 'Other', 'Extra')
> and Uhant."ColX" = 'Whatever' into :MyDbKey do
> begin
> update LargeTable
> set <whatever>
> where rdb$db_key = :MyDbKey;
> end
> END
>
> Using RDB$DB_KEY is probably quicker than using the primary key
> (ECO_ID), though I use it very rarely, so don't be surprised if
> there's some error above.
>
OK, nice. I'll give it a shot on the next update.
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: [email protected]
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
