Can any one tell me what the correct way is to do the following. In
IB5.6 you can have a SP like

as
begin
INSERT INTO POLICYDETAILBU (
BU_DATE, BU_ID, POLICYID, DEPENDANTID, POLICYMAINID, MEMBERID, USERID
) VALUES (
"NOW", GEN_ID(POLICYDETAIL_ID_GEN, 1), old.POLICYID, old.DEPENDANTID,
old.POLICYMAINID, old.MEMBERID, USERID);
end

in 5.6 the value for USERID can from the current record data with IB6
you changed it to new.USERID but non of this will work with Firebird.
Any one tell me the correct syntax
Many thanks
Slim

Slim Roberts
R S Engineering.
Member of the UK Borland User Group