Android Question Problem executing ExecQuery2.

[warayTek]

Hello everyone, I am getting this error message I can not resolve .
The field "slot_time" is a string and room_id is an integer.

Cursor = SQL1.ExecQuery2("SELECT is_available FROM room_status WHERE slot_time = ? AND room_id = ?", Array As Object("10:00 AM",1))

** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create (first time) **
Call B4XPages.GetManager.LogEvents = True to enable logging B4XPages events.
** Activity (main) Resume **
Error in BookAppointment: (ClassCastException) java.lang.ClassCastException: java.lang.Object[] cannot be cast to java.lang.String[]
An error occurred while booking the appointment.

Appreciate the time for helping out.

 

[alwaysbusy]

Have you tried it without the 'As Object'? I normally use a List:

Dim vars as List
vars.Initialize
vars.Add("10:00 AM")
vars.Add(1)

Cursor = SQL1.ExecQuery2("SELECT is_available FROM room_status WHERE slot_time = ? AND room_id = ?", vars)

 

[aeric]

Or try use Array As String("10:00 AM", 1)

 

[warayTek]

Now it works thanks @alwaysbusy & @aeric.