急救:!!!delphi中
adocommand.CommandType:=CMDTEXT;
adocommand.commandtext:=' create or replace trigger TRI_ZXD'+
' before insert on ZXD_BB '+
' for each row '+
'begin SELECT SEQ_BBLSH.NEXTVAL INTO :NEW.BBLSH FROM DUAL; '+
' end TRI_ZXD; '; adocommand.ExecuteOptions:=adocommand.ExecuteOptions+[eoExecuteNoRecords];
my_command.Prepared:=true;
adocommand.execute;
创建触发器失败。程序把 :new.nextval替换成了值。如何处理
急
adocommand.CommandType:=CMDTEXT;
adocommand.commandtext:=' create or replace trigger TRI_ZXD'+
' before insert on ZXD_BB '+
' for each row '+
'begin SELECT SEQ_BBLSH.NEXTVAL INTO :NEW.BBLSH FROM DUAL; '+
' end TRI_ZXD; '; adocommand.ExecuteOptions:=adocommand.ExecuteOptions+[eoExecuteNoRecords];
my_command.Prepared:=true;
adocommand.execute;
创建触发器失败。程序把 :new.nextval替换成了值。如何处理
急
如何实现,高手帮帮忙,只要让adocommand不做换算处理就好了。
性能你的这种实现方法也比trigger好
动态创建修改的trigger失去了它的意义.