Retrieves a result rowset from a query on a connection

Returns > 0 on success, 0 on success but no rows returned, or < 0 on error.

Sample Source Connect MyDatabase to "DSN=dsn_name" as ODBC iResult := GetRowset MyRowset as "Select column1 From Sample" from MyDatabase If iResult > 0 Then GetColumn MyColumn As "column1" From MyRowset Say MyColumn ElseIf iResult = 0 Then Say "No Results" Else Say GetLastError MyDatabase EndIf Disconnect MyDatabase

Sample Source Connect MyDatabase to "DSN=dsn_name" as ODBC PrepareRowset MyRowset as "Select column1 From Sample" from MyDatabase iResult := GetRowset MyRowset If iResult > 0 Then GetColumn MyColumn As "column1" From MyRowset Say MyColumn EndIf Disconnect MyDatabase

Sample Source Connect dbCSV To "FILE=test.csv;QUOTEDTEXT=Y;READONLY=Y" As CSV ir := GetRowset dbRowset As "SELECT *" From dbCSV While ir > 0 GetColumn c1 As 1 From dbRowset GetColumn c2 As 2 From dbRowset GetColumn c3 As 3 From dbRowset GetColumn c4 As 4 From dbRowset Say c1 Say "\n" Say c2 Say "\n" Say c3 Say "\n" Say c4 Say "\n--------\n" ir := SelectRow Next From dbRowset Loop

Related Function(s):
   BindColumn; BindParameter; Connect; GetColumn; GetColumncount; GetColumnname; GetColumnnullability; GetColumnprecision; GetColumnsize; GetColumntype; GetLastError; GetRowCount; PrepareStatement; SelectRow;

Minimum version: 1.0