This is what I made:
But when the parameter passes 0 I get the following error:
Exception: Query returned no rows.
For query: "EXEC ProductDefinition.GetMaterialName 0
"
On Component: 4_1_0_lijn4_Productielijn.Root Container.Text Field 1.ProductName
It is not a problem to me that it is not returning anything when the value is 0 because that is exactly what I want. But I don't want this error to show up every time I update my project in the designer. So is there a solution to disable this error or at least that it is not giving me this error.
