checking whether item has picture or not in report

JAYESHJAYESH Member Posts: 290
HI,

I want to check whether Item has picture or not how to write code in report.

I creat one variable but i didnt find BLOB datatype

So can any one tell how i can check whether item has picture or not if it has picture then one variable is set to *.

Thank you..
JAYESH PATEL

Answers

  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    On the Item-table, the field Picture exists which is a BLOB-field.

    You can use the code
    IF recItem.Picture.HASVALUE THEN
    
    to know if it contains a value.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • JAYESHJAYESH Member Posts: 290
    THANK YOU VERY MUCH

    IT'S WORK..
    JAYESH PATEL
Sign In or Register to comment.