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: kjell.ri...@datadia.se 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/