First I reset and then set some ranges and filters on Shipping Binder
Then when I do
MESSAGE("Shipping Binder".GETFILTERS);
IF "Shipping Binder".FIND('-') THEN
"Shipping Binder".printDoc
ELSE
MESSAGE('This shipping configuration was not found in the database');
I always get the message indicating nothing was found in the shipping binder. however, when I go to this table and manually apply those filters there is definitely a record there. :-k :?:
Here is filter string:
Stage: 1, Package Qty. Max.: 1..|0, Package Qty. Min.: 0|..1, Dest. Country: INT|UG|'', Customer: '', Shipping Agent: NNR|NNR|''
Also when I debug I see that the message is accurate, both the filter string and that no record was found. Any idea why this may be happening? Why would a table behave differently when I enter it manually vs through code?
I know this may be a very hard question to answer. Hopefully someone sees something simple...
Comments
"Show All..."
"Oh..."
I use blank to represent that this applies to all shipments, regardless of Dest. Country for example. Maybe I have to use a keyword like ALL instead of blank?
"Show All..."
"Oh..."
great signature too
2) There are situations when using MS SQL when some entries are not "visible". Which version and database you are using?
3) Off-topic Tip: What you want to do when the entry is not found? Continue in processing? I never saw using Message when something is not found, may be only when debugging...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.