Hello Lev,

the table metadata is:


/* Table: IPAC, Owner: SYSDBA */

CREATE TABLE "IPAC"
(
"IP" INTEGER NOT NULL,
"NDATE" INTEGER NOT NULL,
"INOUT" SMALLINT NOT NULL,
"VAL1" DECIMAL(18, 0),
"VAL2" DECIMAL(18, 0),
"IP_STR" VARCHAR(15),
CONSTRAINT "PK_IPAC" PRIMARY KEY ("IP", "NDATE", "INOUT")
);

the insert statement i use:

$dbh->do("INSERT INTO IPAC (IP, NDATE, INOUT, VAL1, VAL2) VALUES
($ip,$ndate,$inout,$val1,$val2)");

the update statement i use:

$dbh->do("UPDATE IPAC SET VAL1=VAL1+$val1, VAL2=VAL2+$val2 WHERE
(IP=$ip AND NDATE=$ndate AND INOUT=$inout)");


thanks for help

alex

--- In ib-support@y..., Lev Assinovsky <lev@p...> wrote:
> To help you, I need to know
> the data types, the indexes in updated tables.
> What the columns are get updated?
> "Multi-version records" are freed when all transactions are done.
>

> --
> Lev Assinovsky Peterlink Web
> Programmer St. Petersburg, Russia
> Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á
> E-mail: lev@p...