Android Question customlistview

[Tata Mapassa]

Hello, I have a sqlite database with 1 table (Test) and 3 fields (ID, Label, Date). I want each time the application is started to display a customlistview (Icon, label) of all the records with only the Date field corresponding to today's date?
If possible that the label is of a different color from one recording to another?

THANKS

 

[Alexander Stolte]

If possible that the label is of a different color from one recording to another?

Yes, it's possible.

 

[josejad]

I have a sqlite database with 1 table (Test) and 3 fields (ID, Label, Date). I want each time the application is started to display a customlistview

Upload a small project with your code and what you want to achieve. It will make easier to help you

 

[Tata Mapassa]

There

 

[josejad]

Sorry, I just see a B4XTable showing the data. Where's your xCustomListView?

Here an example based on the CLV's original example.

 

[Tata Mapassa]

sorry

 

[josejad]

Have you tried my example?

 

[Tata Mapassa]

Yes, I initially adapted my code to display data with customlistview by following the example but the app crashes.....

 

[josejad]

What error do you get?

 

[Tata Mapassa]

I use the application directly on an Android smartphone after sending the APK from the PC to the phone via Bluetooth.

 

[Tata Mapassa]

I don't use B4A-Bridge

 

[josejad]

I don't use B4A-Bridge

Please, use B4A-Bridge and tell us the error you get.

 

[Tata Mapassa]

Hello, the display query is not working without an error message.
THANKS

 

[josejad]

Hi:

Please, check how to make sql queries. My comment "'Modify the query to select just date = today" is not literal

Check DateTime docs too
Your query should be something like

"SELECT ID, Info, Date FROM Test Where Date = '" & DateTime.Date(DateTime.Now) & "'"

 

[Tata Mapassa]

Everything is OK, thank you for your help.