omron — ODBCIsFieldNULL

Appendix: Built-in Scripting Language ODBCIsEOF Reports whether you have gone beyond the last record of the record set. (Call this function as you scroll from record to record.) Syntax ODBCIsEOF( numHandler ) numHandler The handler returned by the ODBCOpen function. Returned value You can use this function along with the ODBCIsBOF function to determine whether the record set contains any records or is empty. Immediately after calling the ODBCQuery function, and if the record set contains no records, ODBCIsBOF returns non-zero. When you open a record set with at least one record, the first record is the current record and ODBCIsEOF returns a zero ( 0 ).

If the last record is the current record, and you call ODBCMoveNext , ODBCIsEOF will subsequently return a non-zero. Examples ODBCIsFieldNULL Reports whether a specified field in a record set was flagged as NULL . Syntax ODBCIsFieldNULL( numHandler , strColName ) numHandler strColName The handler returned by the ODBCOpen function. The column name. Returned value Examples Page 584 InduSoft Web Studio Function Group Execution Windows Embedded Thin Client ODBCIsEOF ODBC Synchronous Supported Not supported Executed on Server 0 Record found. non-zero Record set contains no records or you moved forward, after the last record.

Tag Name Expression Tag ODBCIsEOF( 5 ) Function Group Execution Windows Embedded Thin Client ODBCIsFieldNU LLODBC Synchronous Supported Not supported Executed on Server 0 The specified field is not flagged as Null. Non-Zero The specified field is flagged as Null. Tag Name Expression Tag ODBCIsFieldNULL( 7, "CustomerName" ) Tag ODBCIsFieldNULL( 3, "CompanyName" )