Appendix: Built-in Scripting Language Notes This function uses the values of the tags bound by the ODBCBindCol function to create the new record. Examples ODBCIsBOF Returns whether you have gone above the first record of the record set. (Call this function before scrolling from record to record.) Syntax ODBCIsBOF( numHandler ) numHandler The handler returned by the ODBCOpen function. Returned value You also can use this function along with the ODBCIsEOF 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 ODBCIsBOF returns a zero ( 0 ). If the first record is the current record, and you call ODBCMovePrev , ODBCIsBOF will subsequently return a non-zero. Examples ODBCIsDeleted Reports whether the current record was deleted. Syntax ODBCIsDeleted( numHandler ) numHandler The handler returned by the ODBCOpen function. Returned value If you move to a record and this function returns a non-zero, then you must move to another record before you can perform any other operations.
Examples InduSoft Web Studio Page 583 Tag Name Expression Tag ODBCInsert( 7 ) Function Group Execution Windows Embedded Thin Client ODBCIsBOF ODBC Synchronous Supported Not supported Executed on Server 0 Record found non-zero Record set contains no records or you move backward, above the first record Tag Name Expression Tag ODBCIsBOF( 1 ) Function Group Execution Windows Embedded Thin Client ODBCIsDeleted ODBC Synchronous Supported Not supported Executed on Server 0 Record set is not positioned on a deleted record. non-zero Record set is positioned on a deleted record. Tag Name Expression Tag ODBCIsDeleted( 8 )