Hi,

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

Guess it's a trigger, not a SP :)

> 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.

What's the error message?

Have you tried changing "NOW" to 'NOW' ?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Any one tell me the correct syntax
> Many thanks
> Slim
>
> Slim Roberts
> R S Engineering.
> Member of the UK Borland User Group