Hi All,
I Designed a FB table as below:
CREATE TABLE LINES
(
PK bigint NOT NULL,
NDOC bigint,
NART bigint,
CLOT varchar(10),
DATE_PER date,
QTE numeric(18,2),
Price numeric(7,2),
PPA numeric(7,2),
CONSTRAINT PK_LIGNES_0 PRIMARY KEY (PK)
);
ALTER TABLE LINES ADD MNT COMPUTED BY (qte*price);
I Show the data via a dbgrid when I update qte or price the field MNT does not !!!
REGARDS