Android Question jdbc select with AnotherDatePicker value date

[EdsonZanatta]

Friends, how can I pass the date value from AnotherDatePicker in a jdbc query?

Grateful

 

[EdsonZanatta]

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

 

[Erel]

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

 

[EdsonZanatta]

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

dim mydate as string = AnotherDatePicker.date ?

 

[Mahares]

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

Do not use anotherDatePicker. Use B4XDateTemplate of xui views. Here is a complete example.

Sub Globals
    Private Dialog As B4XDialog   'need XUI Views checked (internal lib)
    Private DateTemplate As B4XDateTemplate
    Private XUI As XUI 
End Sub

Sub Activity_Create(FirstTime As Boolean)
    Dialog.Initialize (Activity)  'use Root instead of activity if you preferably use a B4XPages project
    Dialog.Title = "Select a date"
    DateTemplate.Initialize
    DateTime.DateFormat= "yyyyMMdd"
    Wait For (Dialog.ShowTemplate(DateTemplate, "", "", "CANCEL")) Complete (Result As Int)
    If Result = XUI.DialogResponse_Positive Then
        Dim mydate As String = $"${DateTime.Date(DateTemplate.Date)}"$
        Log(mydate)
    End If
End Sub

Show us your parameterized query code. I think you could use some help there too.

 

[EdsonZanatta]

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