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.
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