EDIT: Solved
Some descriptions has minus letters in the sentence, but BC turned it into CAPITAL letters, so that there was no matching.
Dear community,
Please help me regarding an issue with the display of blob image.
I have a table (Storage type) with 3 fields: Number, Description, Picture:
table 50010 "Storage"
{
Caption = 'Stockage';
fields
{
field(1; "Code"; Code[10])
{
}
field(2; Description; Text[60])
{
}
field(3; Pictogramme; Blob)
{
Subtype = Bitmap;
}
}
keys
{
key(Key1; "Code")
{
Clustered = true;
}
}
}
In my Item card, I have a field for the storage:
field(50037; "Storage"; Code[50])
{
Caption = 'Stockage';
TableRelation = "Storage".Description;
ValidateTableRelation = false;
}
When selecting a storage type in my item card, I display the related picture in a factbox.
page 50000 "Item Image Factbox"
{
ApplicationArea = All;
Caption = 'Item Image Factbox';
PageType = CardPart;
SourceTable = "Storage";
UsageCategory = None;
layout
{
area(content)
{
field(Pictogramme; Rec.Pictogramme)
{
ToolTip = 'Specifies the picture of the media.';
}
}
}
}
Finally, I get this image displayed on a report:
dataitem(Picto; "Storage")
{
DataItemLink = Description = FIELD("Storage");
column(Pictogramme; "Pictogramme")
{
}
}
trigger OnAfterGetRecord()
begin
ItemCategory.GET(Item."Item Category Code");
//StoragePicto.SETFILTER(Description, '%1', "VERINT Stockage");
//StoragePicto.FINDFIRST();
end;
}
}
var
ItemCategory: Record "Item Category";
StoragePicto: Record "VERINT Stockage";
My problem is the following: only 1 third of the images are displayed, either in the factbox or the report.
I have tried to upload other images in place of the ones that don't display but they don't display neither.
What can I do? Thank you for your kind comments and support
Jay Rome