KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Optional table parameter with the command SET DATABASE PARAMETER
PRODUCT: 4D | VERSION: | PLATFORM: Mac & Win
Published On: May 31, 2002

The command SET DATABASE PARAMETER allows you to define some general parameters in your database.You can consult a full description of this command at https://ftp.4d.com/aci_Technical_notes/ACIDOC/CMU/CMU00642.HTM

As mentioned in it syntax description, this command accepts an optional Table parameter. This parameter is required only for the following selectors:
- Seq Order Ratio Longint (1)
- Seq Access Optimization Longint (2)
- Seq Distinct Values Ratio Longint (3)
- Seq Query Select Ratio Longint (5)

When using the selectors named above, they apply to the current process it is called from and the table passed as a parameter. Other selectors do not require the optional table parameter.