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
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
I've check everything so this problem not a misstypos
Thank You
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
B4X:
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=1its 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
B4X:
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