Android Question Array as Object in ExecQuerySingleResult

[advansis]

Hi guys,
when I try to execute a command like this :

Dim Result as string=SQL.ExecQuerySingleResult2("... my query string ...",Array As Object(Null,1))

I get the error:
java.lang.IllegalArgumentException: method anywheresoftware.b4a.sql.SQL.ExecQuerySingleResult2 argument 2 has type java.lang.String[], got java.lang.Object[]

In Erel's tutorial (here: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content) "array as object" it is used with "ExecNonQuery2".

I think I need the "object array" instead of "string array", because I want to distinguish between NULL values in database an the string "null"...

Thanks in advance.

PS. I do not know the table structure because the query is built at runtime

 

[Erel]

It should be an array of strings in B4A. It is an array of objects in B4J and B4i.

Pass the Null value in the query itself.