Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Next items

JavaCallableStatementMBS.Constructor
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 15.1 Yes Yes Yes Yes No
Function: The private constructor.

Feedback, Comments & Corrections

JavaCallableStatementMBS.getBlob(parameterIndex as Integer) as JavaBlobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.
Notes:
Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getBlob(parameterName as string) as JavaBlobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getBoolean(parameterIndex as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is false.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getBoolean(parameterName as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is false.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getByte(parameterIndex as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getByte(parameterName as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getClob(parameterIndex as Integer) as JavaClobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language.
Notes:
Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getClob(parameterName as string) as JavaClobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getDouble(parameterIndex as Integer) as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getDouble(parameterName as string) as Double
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getFloat(parameterIndex as Integer) as single
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getFloat(parameterName as string) as single
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getInt(parameterIndex as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getInt(parameterName as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getLong(parameterIndex as Integer) as Int64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getLong(parameterName as string) as Int64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getShort(parameterIndex as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
Notes:
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getShort(parameterName as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
Notes:
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getString(parameterIndex as Integer) as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
Notes:
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is null.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.getString(parameterName as string) as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
Notes:
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is null.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, sqlType as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
Notes:
All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject(int) retrieves the value.

parameterIndex - the first parameter is 1, the second is 2, and so on
sqlType - the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
Notes:
This method must be called before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.

parameterIndex - the first parameter is 1, the second is 2, and so on
sqlType - the SQL type code defined by java.sql.Types.
scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the designated output parameter.
Notes:
This version of the method registerOutParameter should be used for a user-defined or REF output parameter. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-defined parameter, the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-defined and REF parameters. Although it is intended for user-defined and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.

Parameters:
paramIndex - the first parameter is 1, the second is 2,...
sqlType - a value from Types
typeName - the fully-qualified name of an SQL structured type

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterName as string, sqlType as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the OUT parameter named parameterName to the JDBC type sqlType.
Notes:
Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject(int) retrieves the value.

Parameters:
parameterName - the name of the parameter
sqlType - the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the parameter named parameterName to be of JDBC type sqlType.
Notes:
This method must be called before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.

Parameters:
parameterName - the name of the parameter
sqlType - SQL type code defined by java.sql.Types.
scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Registers the designated output parameter.
Notes:
This version of the method registerOutParameter should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters. Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.

Parameters:
parameterName - the name of the parameter
sqlType - a value from Types
typeName - the fully-qualified name of an SQL structured type

See also:

Feedback, Comments & Corrections

JavaCallableStatementMBS.setBoolean(parameterName as string, x as boolean)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Sets the designated parameter to the given Java boolean value.
Notes:
The driver converts this to an SQL BIT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

Feedback, Comments & Corrections

JavaCallableStatementMBS.setByte(parameterName as string, x as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Sets the designated parameter to the given Java byte value.
Notes:
The driver converts this to an SQL TINYINT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

Feedback, Comments & Corrections

Next items

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




Links
MBS FileMaker Plugins