SQLParamMBS.DirType as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The direction type of parameter (input, output, etc.).

Use the kParamDirType* constants.

Usually the Library automatically detects parameter's direction type and implicitly creates an appropriate SAParam object. But not all of DBMS clients/servers provide complete parameters information. In that situation programmer need to describe parameter's direction type explicitly. See Server specific notes for details.

https://www.sqlapi.com/ApiDoc/class_s_a_param.html
(Read and Write property)

SQLParamMBS.IsInput as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	20.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Whether this is an input paramater.

Checks ParamType property internally.
(Read only property)

Some examples using this property:

• /SQL/SQL Unit Tests

SQLParamMBS.IsOutput as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	20.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Whether this is an output paramater.

Checks ParamType property internally.
(Read only property)

Some examples using this property:

• /SQL/SQL Unit Tests

SQLParamMBS.Name as string

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The name of the parameter.

(Read only property)

SQLParamMBS.NativeType as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The native type code of the parameter.

(Read and Write property)

SQLParamMBS.Options as Dictionary

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	18.4	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

Returns a dictionary with all options.

For debugging, it may be useful to inspect options in debugger.
(Read only property)

SQLParamMBS.Precision as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The precision of the parameter value (the total number of allowable digits).

(Read and Write property)

SQLParamMBS.Scale as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The scale of the parameter value (the number of digits to the right of the decimal point).

(Read and Write property)

SQLParamMBS.Size as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The parameter's data size.

(Read and Write property)

SQLParamMBS.Type as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	SQL	MBS SQL Plugin	9.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The parameter's data type.

See the kDataType constants.
(Read and Write property)