LOCATE/LOAD A CASE BY ID VARIABLE IN MIDDLE OF ID VARIABLES
Suppose we have ID1, ID2 and ID3, ..., IDNN in database
Locate function allows query with PREFIX
Documentation clearly says to use prefix
locate(dictionary_name, relational_operator, key_prefix)
If there is a way to query using second id or next ids giving a wildcard or something similar (??55)
(This operation could archive using forcase statement, but I interest to use locate and loadcase if there is a way)
Code: Select all
if locate(SURVEY_DICT, >=, "??55") then
do while loadcase(SURVEY_DICT) and ID2 = 55
// process all cases in ID2 55
enddo;
endif;
Disala