v11.3 Bug - QUERY BY FORMULA does not change selection called
Mark Schaake (11/26/08 3:57PM)
Mark Schaake (11/26/08 3:57 PM)
from EXECUTE FORMULA
I just posted this bug to 4d (ACI0060009). I've reproduced it in a
new
database on both Mac 10.5 and Windows XP SP3.
Note: this bug applies to compiled mode only, interpreted works as
expected.
Both QUERY BY FORMULA and QUERY SELECTION BY FORMULA fail to change the
current selection when run from an EXECUTE FORMULA statement. On the
other
hand, QUERY does change the current selection when run from an EXECUTE
FORMULA statement.
Example (code not copied so there may be errors in typing):
[Table_1] contains 1000 records.
[Table_1]Field_1 is a LONGINT, with each record having 1....1000 for
value.
`QUERY BY FORMULA
REDUCE SELECTION([Table_1];0) `clear the current selection
EXECUTE FORMULA(Command name(48)+"([Table_1];[Table_1]Field_1>450)")
ALERT(String(Records in selection([Table_1])) `outputs '550'
interpreted,
'0' compiled = fail
`QUERY SELECTION BY FORMULA
ALL RECORDS([Table_1]) `start with 1000 records
EXECUTE FORMULA(Command name(48)+"([Table_1];[Table_1]Field_1>450)")
ALERT(String(Records in selection([Table_1])) `outputs '550'
interpreted,
'1000' compiled = fail
`QUERY
REDUCE SELECTION([Table_1];0) `clear the current selection
EXECUTE FORMULA(Command name(277)+"([Table_1];[Table_1]Field_1E0)")
ALERT(String(Records in selection([Table_1])) `outputs '1'
interpreted, '1'
compiled = ok
--
View this message in context:
http://www.nabble.com/v11.3-Bug---QUERY-BY-FORMULA-does-not-change-selecti
on-called-from-EXECUTE-FORMULA-tp20711381p20711381.html
Sent from the 4D Tech mailing list archive at Nabble.com.
Reply to this message
Summary created 11/27/08 at 2:06AM by Intellex Corporation
Comments welcome at: feedback@intellexcorp.com