Query Prompt Creating Odd Where Condition For = Operator Follow
Using the Database Connection Setup dialog, I've created a query with a field of 'Shipments.Shipment_ID', and operator of '=', and a criteria of '?EnterShipmentID'.
After providing a number like '1006' to the query prompt while printing a test label, I examined the log and noticed that it produces the follow WHERE condition:
WHERE (("Shipment_ID" >= 1005.95) AND ("Shipment_ID" >= 1006.05))
Querying for a range of numbers is certainly not the expected result when selecting the '=' operator.
I would expect nothing more or less than:
WHERE "Shipment_ID" = 1006
Please sign in to leave a comment.