Skip to Content
0
Jul 28, 2009 at 03:22 AM

bugs in 2007A SP01 PL05 HF2

17 Views

Hi Experts,

I am using B1 2007A SP01 PL05 HF2. I am sure there is a bugs in this new release. I've got error message internal error (8114) occured [message 131-138] when using this following query :


Declare @conv as numeric(19,6)
Declare @Itemcode as nvarchar(20)
Declare @quantity as numeric(19,6)
declare @convqty as numeric(19,6)

set @Itemcode = $[$38.1.0]
set @quantity =   $[$38.11.0]

select @conv=U_con  from OITM where @Itemcode = ItemCode 
set @convqty =  @quantity/@Konv  
if @conv <> 0
begin 
SELECT @convqty 
end 
else 
begin 
select @quantity
end

If I replace this code:


set @Itemcode = $[$38.1.0]
set @quantity =   $[$38.11.0]

with this one:


set @Itemcode = $[$38.1.number]
set @quantity =   $[$38.11.number]

the result is not correct. Pls give adv. how the error could be happened meanwhile in the previous version, the above one is working fine.

Rgd,

Steve