Just completed a semiconductor database in B4A+SQLite, so, it should be possible.
Example:
sought longitude: xlon
sought latitude: ylat
table name: location
field name for longitude: long (stored in *.db as string)
field name for latitude: lat (stored in *.db as string)
field name for related info: description (stored in *.db as string)
An SQLite database file, if packed into the *.apk must be copied to an external location before initialization, such as:
Sub Process_Globals
Dim SQL1 As SQL
Dim Cursor As Cursor
End Sub
Sub Activity_Create(FirstTime As Boolean)
If File.Exists(File.DirDefaultExternal,"mygeo.db") = False Then
File.Copy(File.DirAssets,"mygeo.db",File.DirDefaultExternal,"mygeo.db")
End If
If SQL1.IsInitialized = False Then
SQL1.Initialize(File.DirDefaultExternal, "mygeo.db", False)
End If
End Sub
Then, a query goes something like:
Cursor = SQL1.ExecQuery("SELECT * FROM locations WHERE long LIKE '%" & xlon & "%' AND lat LIKE '%" & ylat & "%'")
For i = 0 To Cursor.RowCount - 1
Cursor.Position = i
ListView1.AddTwoLines2(Cursor.GetString("long") & " " & Cursor.GetString("lat"),Cursor.GetString("description"),i)
Next
Please don't tie me to that, it is just a rough guide. Please also make yourself familiar with SQL queries. Also, note that values in a databases maybe stored otherwise than in strings.
Please also refer to the SQL tutorial posted here:
Basic4android - Android programming with Gui designer