Cursor1 = SQL1.ExecQuery("SELECT
cotiza.ultimoleido,posicion.PF,posicion.id,cotiza.sector,posicion.especie,
posicion.cantidad,posicion.costo,cotiza.ultimo,cotiza.dia,cotiza.cantbid,
cotiza.bid,cotiza.ask,cotiza.cantask,posicion.comiscompra,posicion.sl,posicion.sg
FROM posicion
left outer join cotiza on cotiza.especie=posicion.especie
order by posicion.especie")
This is the same but group by and brigs 0 rows
B4X:
Cursor1 = SQL1.ExecQuery("SELECT
posicion.especie,max(cotiza.sector),max(cotiza.ultimoleido),min(posicion.PF),
min(posicion.id),sum(posicion.cantidad),avg(posicion.costo),max(cotiza.ultimo),
max(cotiza.dia),max(cotiza.cantbid),max(cotiza.bid),max(cotiza.ask),
max(cotiza.cantask),sum(posicion.comiscompra),min(posicion.sl),
max(posicion.sg)
FROM posicion
left outer join cotiza on cotiza.especie=posicion.especie
group by posicion.especie
order by posicion.especie")
Any tool with which I can test queries before using it in the app?
Thanks
The problem can only be one of the three below (I THINK):
1) the query tested in SQLite expert Is not the same used in the project
2) the db used in SQLite Expert is not the same used in the project
3) displaying the results in the project is wrong.
1) the query is copied from the source code withot any modification.
2) the db is copied from the phone to a new folder that had no db in it, its the same.
3) ??
I will make an little app to demostrate the problem, may making it I'll find the bug <G>
Your best bet is to zip your project or a miniature project, do not forget to include your database or a portion of it. Someone in the forum will discover the problem.
Are you really 14 years old? If you are not pulling our chains, then perhaps in a few years you will become Erel and Manfred combined in one.
Your best bet is to zip your project or a miniature project, do not forget to include your database or a portion of it. Someone in the forum will discover the problem.
Are you really 14 years old? If you are not pulling our chains, then perhaps in a few years you will become Erel and Manfred combined in one.