[Solved] Put Formula in Column - Calculated Column

[peterwt]

I have a Table, Table1, with two Columns, a and b both integers. I want a third Column Total which is a + b. You can run a Query to give the Totals but this does not change the Table. I want to be able to enter values for a and b and have Total created when the Record is added. Similar to a spread sheet where the formula is in a cell.

I have seen in other applications you can use SQL

Code: Select all

ALTER TABLE "Table1" ADD COLUMN "Total" INTEGER AS ("a" + "b") PERSISTED

I get error "Unexpected token: AS in statement [AS]"

Code: Select all

ALTER TABLE "Table1" ADD COLUMN "Total" INTEGER

does work.

[F3K Total]

Hello,
it's not possible with the shipped embedded database HSQLDB 1.8.10. If you split your DB (see Base Tutorials) you can e.g. use HSQL 2.3.3 currently, which can generate calculated columns as well as triggers.

R

[peterwt]

Thanks F3K Total