Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

SQLParamMBS.DirType as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The direction type of parameter (input, output, etc.).
Notes:
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.

http://www.sqlapi.com/OnLineDoc/Param_ParamDirType.html
(Read and Write property)

Feedback, Comments & Corrections

SQLParamMBS.Name as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The name of the parameter.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLParamMBS.NativeType as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The native type code of the parameter.
Notes: (Read and Write property)

Feedback, Comments & Corrections

SQLParamMBS.Options as Dictionary
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 18.4 Yes Yes Yes Yes No
Function: Returns a dictionary with all options.
Notes:
For debugging, it may be useful to inspect options in debugger.
(Read only property)

Feedback, Comments & Corrections

SQLParamMBS.Precision as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The precision of the parameter value (the total number of allowable digits).
Notes: (Read and Write property)

Feedback, Comments & Corrections

SQLParamMBS.Scale as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The scale of the parameter value (the number of digits to the right of the decimal point).
Notes: (Read and Write property)

Feedback, Comments & Corrections

SQLParamMBS.Size as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The parameter's data size.
Notes: (Read and Write property)

Feedback, Comments & Corrections

SQLParamMBS.Type as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The parameter's data type.
Notes:
See the kDataType constants.
(Read and Write property)

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS Xojo blog