Android Question Bug on select 3 tables sqllite?

[Reids]

Hello All
Recently trying to select 2 tables on B4A sqllite it fine, but it problem when selecting 3 tables on B4A
here's my query on sqllite manager (mozzila firefox addon) its fine, but on B4A doesn't return row correctly

select faktor.nm_fak as nmfak,faktordat.dat_rial as dafak from faktorial,faktordat,faktor where faktorial.id_rial=faktordat.id_rial and faktor.id_fak=faktordat.id_fak AND faktordat.id_rial=1

its fine it return correctly 4 row data as I wanted on sqllite manager, but there's problem when I compiled on B4A, it return only 2 row

lvfaktorialload = SQL1.ExecQuery("select faktor.nm_fak as nmfak,faktordat.dat_rial as dafak from faktorial,faktordat,faktor where faktorial.id_rial=faktordat.id_rial and faktor.id_fak=faktordat.id_fak AND faktordat.id_rial=" & "'" & pckvalue & "'")
Msgbox(lvfaktorialload.RowCount,"rowcount")

I've check everything so this problem not a misstypos
Thank You

 

[LucaMs]

Most likely the query is executed on a different version of db

 

[Reids]

OMG
I didn't notice that my pc and my phone has diference db which the phone db has been modified before
problem solved by clearing app cache so db is copied freshly
Thank You!