Android Question ExecQuerySingleResult2 bug?

ebalvis

Member
Licensed User
Longtime User
I am doing the following query
the results are different
what is the problem


SQL.ExecQuerySingleResult("SELECT count(*) FROM SOLICITUDES WHERE CLAVE=1135351")
result=1 its OK

SQL.ExecQuerySingleResult2(sbInsertQuery.ToString,ArrayAsString(1135351)))
sbInsertQuery.ToString="SELECT count(*) FROM SOLICITUDES WHERE CLAVE=?"
result=0 fail.
 

ebalvis

Member
Licensed User
Longtime User
Can you create a small project that demonstrates this issue and upload it?

I've found the problem
This table is created automatically with a JSON response.
The field type in responses was not defined in the function that creates the table,
The field is created only with type "PRIMARY KEY"
I understand that the function ExecQuerySingleResult2 misconstrued the field type and performing the conversion to a different type of INTEGER
Thanks anyway
 
Upvote 0
Top