Android Question [SOLVED] What is wrong with this query ?

incendio · Dec 16, 2025

Hi guys,

I have this codes

B4X:

Dim qry As String = "SELECT o.DT, o.FRM_N, " & _
                    "FROM T_IN_OT2 i " & _
                    "JOIN T_IN_OT1 o ON o.ID = i.ID_IN_OT1 " & _
                    "JOIN M_TRS_TYP mt ON mt.ID = o.ID_TRS_TYP " & _
                    "JOIN M_FNGD f ON f.ID = i.ID_GD " & _
                    "WHERE o.DT BETWEEN ? AND ? " & _
                    "AND mt.ID = ? " & _
"AND ( ? = -1 OR f.ID = ? ) " &_
                    "ORDER BY o.DT, o.FRM_N, f.ID"

Private db As Cursor
db = SQLTbl.ExecQuery2(qry,Array As String("2025-10-01", "2025-12-31", 41,-1,-1))

It returns empty result

But if query change to this

B4X:

Dim qry As String = "SELECT o.DT, o.FRM_N, " & _
                    "FROM T_IN_OT2 i " & _
                    "JOIN T_IN_OT1 o ON o.ID = i.ID_IN_OT1 " & _
                    "JOIN M_TRS_TYP mt ON mt.ID = o.ID_TRS_TYP " & _
                    "JOIN M_FNGD f ON f.ID = i.ID_GD " & _
                    "WHERE o.DT BETWEEN ? AND ? " & _
                    "AND mt.ID = ? " & _

                    "ORDER BY o.DT, o.FRM_N, f.ID"

Private db As Cursor
db = SQLTbl.ExecQuery2(qry,Array As String("2025-10-01", "2025-12-31",41))

It returns data.

What is wrong with my code?

incendio · Dec 17, 2025

Solved it.

Here is for reference to others, change query and its arguments to this

B4X:

Dim qry As String = "SELECT o.DT, o.FRM_N, " & _
                    "FROM T_IN_OT2 i " & _
                    "JOIN T_IN_OT1 o ON o.ID = i.ID_IN_OT1 " & _
                    "JOIN M_TRS_TYP mt ON mt.ID = o.ID_TRS_TYP " & _
                    "JOIN M_FNGD f ON f.ID = i.ID_GD " & _
                    "WHERE o.DT BETWEEN ? AND ? " & _
                    "AND mt.ID = ? " & _
"AND ( ? = '-1' OR f.ID = ? ) " &_
                    "ORDER BY o.DT, o.FRM_N, f.ID"

Private db As Cursor
db = SQLTbl.ExecQuery2(qry,Array As String("2025-10-01", "2025-12-31", 41,"-1",-1))

Erel · Dec 17, 2025

Why don't you use smart strings???

B4X:

Dim qry As String = $"SELECT o.DT, o.FRM_N,
                    FROM T_IN_OT2 i
                    JOIN T_IN_OT1 o ON o.ID = i.ID_IN_OT1
                    JOIN M_TRS_TYP mt ON mt.ID = o.ID_TRS_TYP
                    JOIN M_FNGD f ON f.ID = i.ID_GD
                    WHERE o.DT BETWEEN ? AND ?
                   AND mt.ID = ?
                   AND ( ? = '-1' OR f.ID = ? )
                    "ORDER BY o.DT, o.FRM_N, f.ID"$

incendio · Dec 18, 2025

Erel said:

Why don't you use smart strings???

B4X:

Dim qry As String = $"SELECT o.DT, o.FRM_N,
                    FROM T_IN_OT2 i
                    JOIN T_IN_OT1 o ON o.ID = i.ID_IN_OT1
                    JOIN M_TRS_TYP mt ON mt.ID = o.ID_TRS_TYP
                    JOIN M_FNGD f ON f.ID = i.ID_GD
                    WHERE o.DT BETWEEN ? AND ?
                   AND mt.ID = ?
                   AND ( ? = '-1' OR f.ID = ? )
                    "ORDER BY o.DT, o.FRM_N, f.ID"$

That is just an example.
On actual code, that query stored in sqlite table so I can build a report utility based on different queries.

Android Question [SOLVED] What is wrong with this query ?

incendio

Well-Known Member

incendio

Well-Known Member

Erel

B4X founder

incendio

Well-Known Member

Similar Threads

Android Question [SOLVED] What is wrong with this query ?

incendio

Well-Known Member

incendio

Well-Known Member

Erel

B4X founder

incendio

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency