KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.