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

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.