Hello,
I have create a small sqlite database for manag emy money usage.
i add data inside a table, and I view it inside a clv.
My problem, is that if I add a field with data before, the order is not correct by DATE.
I use this query for oder data by DATE:
I attach the project. the database have no data.
try to add a value for today, then one with date before, and then with date 1/1. It not order by date...
feel free to make impovements
Thank you
I have create a small sqlite database for manag emy money usage.
i add data inside a table, and I view it inside a clv.
My problem, is that if I add a field with data before, the order is not correct by DATE.
I use this query for oder data by DATE:
B4X:
rs = SQL1.ExecQuery2($"SELECT idmov, Data, Tipo, Destinatario,Descrizione,Conto,Importo FROM tbl_movimenti BY ORDER BY DATA ASC"$, Null)I attach the project. the database have no data.
try to add a value for today, then one with date before, and then with date 1/1. It not order by date...
feel free to make impovements
Thank you