Happy to have hurdled a stumbling block, on accessing an sqlite database. I watched Dana Brown’s short webinar " Xojo Desktop App Database Tutorial: Connecting a SQLite Database", and just followed it faithfully. The code that works for me are:
db = New SqLiteDatabase
var f as FolderItem = SpecialFolder.Resource(“bisoogo.sqlite”)
Thanks to all who responded and gave me many ideas.