I am trying to do a Query Selection By Formula that links two tables by the
filed ItemNum
with the condition that the value of a field in the first table does not equal
a value in the second table.
When I look at the ResultPlan there is a Join on the Price fields even when I
used the # comparison.
How do I define a comparison vs a join ?
C_TEXT($vResultPlan;$vResultPath)
DESCRIBE QUERY EXECUTION(True) //analysis mode
Query Selection by Formula([ItemDiscounts];\
( ([ItemDiscounts]ItemNum=[Items]ItemNum) \
& ([ItemDiscounts]BasePrice#[Items]PriceB) \
& ([Items]PriceA#0)))
$vResultPlan:=Get last query plan(Description in text format)
ConsoleMessage("vResultPlan\r"+$vResultPlan)
$vResultPath:=Get last query path(Description in text format)
ConsoleMessage("vResultPath\r"+$vResultPath)
DESCRIBE QUERY EXECUTION(False) //End of analysis mode
vResultPlan
Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum &
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0
vResultPath
Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum &
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0 (3247 records found in 4 ms)
--> 4030 records found in 22 ms
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
