SQLiteDataSet.cls
Friend Function FInit(ByVal hStmt As Long) As Boolean

While Result = SQLITE_ROW

For iCol = 0 To (Count - 1)
Select Case stub_sqlite3_column_type(hStmt, iCol)
Case SQLITE_INTEGER
Result = stub_sqlite3_step(hStmt)
Wend


If there are 10,000 rows and 30 columns of data, you need to detect the data type 300,000 times. If there is a BUG here, you can change it to only detect the data type 30 times and save it in the array.
ReDim Preserve PropValues.Rows(0 To ArrUBound) As TCOLS
Can you get the number of data rows at one time and allocate all the data to the array?

Is the design method here to read all rows and columns of data into a two-dimensional array at a time?
Is there another mode to read only one row of data at a time, move to the next row, and then read one row of data (multiple columns of data into an array)?