Command: SQL_FetchNext

Display all  Hide all

Command: SQL_FetchNext

Transfers the next SQL result block.

Call SQL_FetchNext()

Input Parameters

Return Parameters

SQL_Next	Specifies whether the Select result includes other data blocks. Boolean variable The SQL_Next variable can contain the following values: Value Meaning 0 No other data blocks are available in the Select result. 1 Other data blocks are available in the Select result.
SQL_Stat	Receives the status of an SQL command. Longinteger variable The SQL_Stat variable can contain the following values: Value Meaning >=0 The operation was successful. <0 An error occurred.

DIAdem transfers the first SQL result block after a SELECT command.

Note  Refer to the page on The ODBC/SQL Interface for general information about the ODBC/SQL commands. The SQL Script Command Examples show how to use the ODBC/SQL commands.

Note  Use the ADO interface to access databases in VBS.

Example

The following example opens the Example.mdb data store and transfers the data from the Speed column to the new MySpeed data channel in the Data Portal. The example then disconnects the Example.mdb data store.

Call Data.Root.Clear()
Call SQL_Connect("Example", "","","")
If (SQL_ConnectStat = true) Then
  Call SQL_ExecDirect("Select * From Example")
  If (SQL_Stat > 0) Then
    Call SQL_BindChannel("MySpeed","Speed","n")
    Do While SQL_Next
      Call SQL_FetchNext()
    Loop
  End If
  Call SQL_DisConnect
End If

dd.Data.Root.Clear() 
SQL_Connect("Example", "","","") 
if (SQL_ConnectStat == True) : 
    SQL_ExecDirect("Select * From Example") 
    if (SQL_Stat > 0) : 
        SQL_BindChannel("MySpeed","Speed","n") 
        while Do : 
            SQL_FetchNext() 
    SQL_DisConnect 

Related Topics

Command: SQL_AutoCommit | Command: SQL_Delete | Command: SQL_ExecDirect | Command: SQL_Insert | Command: SQL_Select | Command: SQL_Transact | Command: SQL_Update | Examples | ODBC/SQL