Android Question jdbc select with AnotherDatePicker value date

I was able to execute the query by passing the AnotherDatePicker parameter. But the query returns empty filtering by the date entered, but there is data in the database, from my back I query successfully. What could be wrong with this query? And how do I test the result of a jdbcresult?, if it is empty?

Try
Dim sqlquery As String
DateTime.DateFormat = "yyyyMMdd"
Private sDate = DateTime.Date(dtp1.date) As String
Log(sDate)

sqlquery = "select count(distinct(pedido)) as qtped, sum(qtde * valor) as valped from itens_pedido where data = '" & sDate & "'"
sqlquery= sqlquery & " and status= 'P' "
Dim SenderFilter As Object = conexao.sql1.ExecQueryAsync("SQL", sqlquery, Null)
Wait For (SenderFilter) SQL_QueryComplete (Success As Boolean, rs As JdbcResultSet)
If Success Then
If rs.NextRow Then
Do While rs.NextRow

1. Please use [code]code here...[/code] tags when posting code.
2. We don't write queries like this. You should use parameterized queries. See tip #5: https://www.b4x.com/android/forum/t...ommon-mistakes-and-other-tips.116651/#content

Yes, Erel, thank´s. My problem now is get date value from AnotherDatePicker for use in query, example:

dim mydate as string = AnotherDatePicker.date ?

EdsonZanatta said:

My problem now is get date value from AnotherDatePicker for use in query, example:

Click to expand...

Do not use anotherDatePicker. Use B4XDateTemplate of xui views. Here is a complete example.
Show us your parameterized query code. I think you could use some help there too.

Thank you very much for the suggestion. I'll research this.