Tech Tip: How many query arguments can I have in a single query?
PRODUCT: 4D | VERSION: 2004 | PLATFORM: Mac & Win
Published On: October 24, 2007
4D 2004 allows 1024 query arguments within a single query. Programmatically, this is possible with the command QUERY.
The QUERY command allows you to build a query with multiple query arguments with the optional * parameter. For instance, the following:
QUERY([State];[State]Name="a@";*) QUERY([State]; |; [State]Name="b@";*) QUERY([State]; |; [State]Name="c@") |
can be read as:
Query the State table where the field Name begins with the letter "a"
or "b" or "c"
Therefore, the 3 QUERY calls above can be extended to a maximum of 1024 calls.