question again

[airpumpkin]

hi,

meat problem again. how can I input all the items in a table got by sqlite?
the main difficulty is that I can't get how many items in the table.


THX

[Worm]

Use Table.Count to find the number of rows in the table. That'll tell you how many records you have.

[airpumpkin]

I have tried this, but I can't get the correct result.
it only returns me 4, they are ColumnNames, Rows, Data, Columns.

[Worm]

Sorry I should have read more carefully.

Use: .Rows

tblRecordSet = SQLite.QueryToTable(...

for n=1, tblRecordSet.Rows do

end

[airpumpkin]

thx Worm! it works correctly.