f2s_server_hint_optimization_state¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

ONLY USE THIS WHEN INSTRUCTED TO BY THE MERTECH SUPPORT STAFF.

Syntax¶

set_attribute f2s_server_hint_optimization_state of {DriverID} (f2s_ConstPointer({server})) to {variable}
get_attribute f2s_server_hint_optimization_state of {DriverID} (f2s_ConstPointer({server})) to {variable}

Parameter	Description
DriverID	The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID.
server	Pointer to a string. Pointer to the name of the database server.
variable	f2s_default_hints (-1), f2s_no_hints (0) and f2s_force_hints(1)

Description¶

This only affects database access when using DataFlex commands (find, save, datadictionary actions, ect).

This allows the user to turn on/off index hints on the server. Setting this attribute to f2s_default_hints will cause the server to use the default settings for hints. For Microsoft SQL Server, hints are off by default. However, in Oracle, they are on.

f2s_default_hints: using the default for the server f2s_no_hints: turn hints off f2s_force_hints: turn hints on

When to Use¶

ONLY USE THIS WHEN INSTRUCTED TO BY THE MERTECH SUPPORT STAFF. This not only effects how a query is run, but what rows are locked and when, where and what data is returned.

Examples¶

get_attribute

string sServer
integer iHints

Get_Attribute f2s_server of _f2s_ActiveDriverId to sServer
Get_Attribute f2s_server_hint_optimization_state of _f2s_ActiveDriverID (f2s_ConstPointer(sServer)) to iHints

set_attribute

string sServer

Get_Attribute f2s_server of _f2s_ActiveDriverId to sServer
Set_Attribute f2s_server_hint_optimization_state of _f2s_ActiveDriverID to f2s_force_hints

Replaces¶

NATIVE_OPTIMIZATION using SERVER