Database "Members" Error???

Databases
1

Hi,
When a user enters text into a search field - my listbox updates to only show entries matching the entered search criteria.

Can someone please advise me why I keep getting the following 2 error messages:

  1. Type “SQLiteDatabase” has no member named “Field”

  2. Type “SQLiteDatabase” has no member named “moveNext”

Both of these errors are in the While / Wend loop

[code] // SEARCH FIELD HAS TEXT, SO EXECUTE THE SEARCH
If NSSearchField2.stringValue <>"" Then

Dim ps As SQLitePreparedStatement = ColoursDB.Prepare("SELECT * FROM Colours WHERE Description LIKE ?;")
ps.BindType(0, SQLitePreparedStatement.SQLITE_TEXT)
ps.Bind(0, "%" +NSSearchField2.stringValue + "%")
ColoursRS = ps.SQLSelect

// ERROR EXECUTING THE DATABASE SQL
If ColoursDB.Error Then
  MsgBox("Error: " + Str(ColoursDB.ErrorCode) + " - " + ColoursDB.ErrorMessage)
  
  // NO DATABASE COMMUNICATION PROBLEMS, SO RE-POPULATE THE COLOURS DATABASE TO SHOW ONLY ENTRIES MATCHING THE SEARCH CRITERIA 
Else
  ColoursWindow.Listbox2.deleteAllRows
  
  While Not ColoursRS.eof
    ColoursWindow.Listbox2.AddRow
    ColoursWindow.Listbox2.Cell(ColoursWindow.Listbox2.LastIndex, 1) = ColoursDB.Field("Description").StringValue
    ColoursDB.moveNext
  Wend
  
End If



// NO SEARCH CRITERIA ENTERED, SO DISPLAY ALL COLORS

Else
ColoursWindow.UpdateColoursTimer.Mode = CodeSnippetsWindow.UpdateColoursTimer.ModeSingle

End If[/code]

Thank you all in advance for any help you can provide.

2

Did you look at the documentation?
SQLiteDatabase has no member named Field, or MoveNext.
Those are both functions of RecordSet.

3

Stupid typo!
I meant to type ColoursRS, but typed ColoursDB instead!

Thanks Tim.