> From: "sugi" <truesaint@...>
> Is there any way for a computed field to derive its value from other
> dataset?
> I'm thinking of something like :
> ...
> alter table master
> add DetailCount integer computed by
> (select count(*) from detail where (master.masterid =
> detail.masterid))

Add a pair of parenthesis (one is required by COMPUTED BY,
the other is needed in order SELECT to become expression).

> The above query doesn't work...:)

I "love" the description of problem "IT DOES NOT WORK" !!! AAAAARGH! :-)


Ivan
http://www.volny.cz/iprenosil/interbase