At 06:43 AM 01-10-02 -0400, you wrote:

>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

1. A stored procedure using context variables? I don't think so.

2. Change "NOW" to 'NOW' (single quotes) or, if this doesn't work, to
CAST('NOW' AS TIMESTAMP) or CURRENT_TIMESTAMP.

heLen