[VSDK Macho/PB] Wishes and performance stuff

[Frank Bitterlich]

FWIW, I believe the SQL92 syntax for this is

UPDATE HolderTable H SET Totalshares=(select SUM(shares) from
ShareRecord where S.parentHolder=H.recid)

Cheers,
   Frank+++

Totte Alm wrote:
> 
> tisdagen den 21 januari 2003 kl 13.25 skrev Ruslan Zasukhin:
> 
> > on 1/21/03 1:57 PM, Totte Alm at totte at code66.se wrote:
> >
> >> UPDATE HolderTable  H, ShareRecord S SET H.Totalshares=SUM(S.shares)
> >> WHERE S.parentHolder=H.recid
> >>
> >> or this
> >>
> >> UPDATE HolderTable  H, ShareRecord S SET H.TotalVotes=SUM(S.shares)
> >> WHERE (S.parentHolder=H.recid) AND H.BuyBack=0
> >
> > Btw, anybody can do this ?
> 
> I dont know, I just realized that that would make my life 100 times
> easier (and my app 100 times faster).
> 
> // Totte


--
Günter Schmidt & Co. oHG         
Frank Bitterlich             eMail: bitterlich at gsco.de
Schlosserstr. 4              WWW:   http://www.gsco.de/gsco
D-60322 Frankfurt            Tel.:  069 / 156809-29
GERMANY                      Fax:   069 / 156809-28