Valentina Database Mantis - VSERVER
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
4693 [VSERVER] SQL feature always 2010-01-14 16:51 2010-01-14 16:51
Reporter: Bart Pietercil Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 4.3.1  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0004693: Kernel error: 0x71000. line 12:66: expecting UINT, found 'aLevel'; request instead of fixed value an expression or variable
Description: this procedure:
create or replace procedure GetCellManagerForJT(aJT llong,aLevel Integer,HowMany integer)
begin
declare CellPtr, aPtr llong;


case
   when aLevel = 0 Then
       set CellPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;

   when aLevel < 0 THEN
       set aPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;
       set CellPtr = select recid FROM (descendants of aPtr on Level aLevel using cell_has_parent);

   when aLevel > 0 THEN
       set aPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;
       set CellPtr = select recid FROM (ascendants of aPtr on Level aLevel using cell_has_parent);
end case

if CellPtr is null then
   raise 50001,'No Cell found on the passed level';
else
   if HowMany = 1 then
       select RecID from tbl_cellmanagers where objptr_cell = CellPtr limit 1;
   else
       select RecID from tbl_cellmanagers where objptr_cell = CellPtr;
   end if
end if

exception
   when others then
       raise;

end
Kernel error: 0x71000. line 12:66: expecting UINT, found 'aLevel'
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:
Issue History
Date Modified Username Field Change
2010-01-14 16:51 Bart Pietercil New Issue

There are no notes attached to this issue.