I have at last managed to get the emulator working. Target Android 4.2.2. API 17 ARM. I think it was a lack of patience on my part! When I run SQLiteLight3 on the emulator it shows the table.
Q1: In emulator edit mode the characters from the table are not showing, only a red line is this normal?
When connected, my device it is not displaying the table, only the header 'SQLiteLight3' and 4 keys are showing on the screen. There is an error message showing on the Log:
android.database.sqlite.SQLiteException: no such column: LastName (code 1): , while compiling: SELECT ID As [ID], FirstName As [First name], LastName As [Last name], City As [City] FROM persons.
Q2: Should there be a Table downloaded to the device as a file?
Q3: Is there a particular directory where I should see this file?
Q4: If there is a file downloaded what is its name?