ISDBEOF

Applies to	SQLBat (Module: SQLBatX.dll)
Group	Processing
See also	READROW, CLEARROW

Checks if the end of a recordset has been reached. You can use this method to check if your SQL statement found any records matching the specified criteria.

Syntax

ISDBEOF  <VariableName>[, <ConnectionKey>]

Part	Description
<VariableName>	Name of a script variable where the method stores a 0 (end of recordset not reached yet) or 1 (no current record).
<ConnectionKey>	A shortname to identify the database connection for which the option is set. It can be omitted if you have previously specified the ConnectionKey once before.

Sample

SUB MAIN
  DEBUGMODE ON
  USINGDB Mydb
  SETMDBODBCCONSTR "C:\Test.mdb"
  CONNECT
  OPENQUERY "SELECT * FROM test", Rows
  MSGBOX %SCR.Rows%
  WHILE 1 = 1    
    READROW
    VIEWROW
    GOTONEXTROW r
    IF %SCR.r% = 0 THEN EXITLOOP
  WEND
  CLOSEQUERY
  DISCONNECT
END SUB