|
|
|
Sets the value of a FairCom DB SQL statement’s input parameter to null. This method is common to the SQLCursor, SQLIStatement, and SQLPStatement classes. This method is redundant with using the setParam() method to set a statement’s input parameter to null.
Format
public void makeNULL(int f)
Returns
None
Parameters
f
An integer that specifies which input parameter of the FairCom DB SQL statement string to set to null (1 denotes the first input parameter in the statement, 2 denotes the second, and so on).
Throws
DhSQLException
Example
CREATE PROCEDURE sc_makeNULL()
BEGIN
SQLCursor select_btypes = new SQLCursor (
"SELECT small_fld from sfns where small_fld = ? ");
select_btypes.makeNULL(1);
select_btypes.open();
select_btypes.fetch();
select_btypes.close();
END
