create or replace function Get_SeqId
return integer
is
V_SEQID INTEGER;
begin
update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 where
fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID';
select FLDCOUNTD into V_SEQID from tab_autonumber where
fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID';
return V_SEQID;
end Get_SeqId;怎么在update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 中会提示出错
return integer
is
V_SEQID INTEGER;
begin
update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 where
fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID';
select FLDCOUNTD into V_SEQID from tab_autonumber where
fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID';
return V_SEQID;
end Get_SeqId;怎么在update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 中会提示出错
fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID';编译自订函数也成功,,但执行select 语句调用这个函数出错无法在查询中执行dml操作