item price using boi in sage 100 /mass 90 /mass 200

SOLVED

Hi 

i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string .

can any one help me out on how to read a int or double value using boi in sage 100 ?

thanks 

  • 0
    verified answer
    perhaps check the use of the $ sign in your attempt to get the column value

    Use trailing $ when getting string values
    Do not use trailing $ when getting numeric values

    depending on language
    vb
    dim some_string as string

    pascal
    var
    some_string : string;

    oBusObjB.nGetValue("StringColumn$", some_string) //note $ at end of column name


    depending on language
    vb
    dim x as integer

    pascal
    var
    x : integer;


    remove the '$' when getting numeric values
    oBusObjB.nGetValue("NumericColumn", x) //no trailing $ at end of column name
  • 0 in reply to sevendogzero
    Hi sevendogzero,
    Thanks a lot for your response
    it solved the problem