SQL_Result, 100 row limit

[Julia Dawkins]

When executing an SQL string using the SQL_ExecDirect command, one of the most useful return paramters for me is SQL_Result.  However, this only allows the return of 100 rows.  Is there a way to execute an SQL string and return more than 100 rows? 

Thank you!

Julia

[Walter_Rick]

Hi Julia,

The number of columns is limited up to 100. The number of rows returned in one step is 200000. If you expect more than 200000 values per column than you can use the command SQL_Next and SQL_Fetchnext. SQL_Next is true until the last value is read and SQL_Fetchnext transferes the next block.

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

I hope this can help you.

Greetings
Walter