Not geting Dimension Name

VBH

No Table
352 : Default Dimension as DefaultDimension
349 : Dimension Value as DimensionValue
DerivativeName Varibale Name

I want to Read data from Table default Dimension based on KEY (Table ID,No.,Dimension Code) based on Table "Sales Invoice Line"'s No Fields

then I need Name form Table Dimension Value.

I have written this code


DefaultDimension.RESET;

DefaultDimension.SETCURRENTKEY("Table ID","No.","Dimension Code");
DefaultDimension.SETFILTER("Table ID",'27');
DefaultDimension.SETFILTER("Dimension Code",'PRODCATEGORY');
DefaultDimension.SETRANGE(DefaultDimension."No.","Sales Invoice Line"."No.");

IF DefaultDimension.FIND THEN
BEGIN
//DimensionValueCode:=DefaultDimension."Dimension Value Code";
DimensionValue.SETRANGE(DimensionValue.Code,DefaultDimension."Dimension Value Code") ;
IF DimensionValue.FIND THEN
DerivativeName:=DimensionValue.Name;
END
ELSE
DerivativeName:='';


When i checked in debuging mode there is no value DefaultDimension

do needful or guide me where i am doing mistake.
With Thanks and Regards
VBH

mohana_cse06

VBH wrote:

IF DefaultDimension.FIND THEN

Try IF DefaultDimension.FINDFIRST THEN