| Subject | COMPUTED BY (SELECT SUM("Cost") FROM Costs WHERE Costs.ID = ID) |
|---|---|
| Author | Raymond Kennington |
| Post date | 2003-04-07T11:54:12Z |
The manual states that <expr> for a COMPUTED column can be any valid query that returns a single
result set.
The following gives an error like 'unknown token' for SELECT:
COMPUTED BY (SELECT SUM("Cost") FROM Costs WHERE Costs.ID = ID)
so is it possible?
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)
result set.
The following gives an error like 'unknown token' for SELECT:
COMPUTED BY (SELECT SUM("Cost") FROM Costs WHERE Costs.ID = ID)
so is it possible?
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)