Android Question Error in parameter Sql query

[omidaghakhani1368]

Hi.
I use below code for get row count but get error
sql1.ExecQuerySingleResult2("SELECT COUNT(*) FROM tbl_friends WHERE sID ='?'",Array As String(user_id)) = 0 Then

error : android.database.sqlite.SQLiteBindOrColumnIndexOutOfRangeException: bind or column index out of range: handle 0x149eb8

 

[Pendrush]

sql1.ExecQuerySingleResult2("SELECT COUNT(*) FROM tbl_friends WHERE sID=?",Array As String(user_id)) = 0 Then

remove ' before and after ?

 

[omidaghakhani1368]

sql1.ExecQuerySingleResult2("SELECT COUNT(*) FROM tbl_friends WHERE sID=?",Array As String(user_id)) = 0 Then

remove ' before and after ?

Thank you but my string dont have a quote.are you sure?

 

[mangojack]

maybe

Dim rowCount As Int = sql1.ExecQuerySingleResult2("SELECT COUNT(*) FROM tbl_friends WHERE sID=?",Array As String(user_id))
If rowCount = 0 Then

 

[omidaghakhani1368]

maybe

Dim rowCount As Int = sql1.ExecQuerySingleResult2("SELECT COUNT(*) FROM tbl_friends WHERE sID=?",Array As String(user_id))
If rowCount = 0 Then

Thank you,i test it but get error.it is wonderfull

 

[sorex]

Thank you but my string dont have a quote.are you sure?

IDs are numbers most of the time then you don't need to use quotes

 

[omidaghakhani1368]

IDs are numbers most of the time then you don't need to use quotes

I know.Number field in my table is type of TEXT and i according field type decide to use quote

 

[sorex]

I'm not 100% sure about SQLite but I believe it's always text but it detects on the content if it is a number, date, datetime or real string field.

 

[omidaghakhani1368]

I'm not 100% sure about SQLite but I believe it's always text but it detects on the content if it is a number, date, datetime or real string field.

use quote according to field's type In all databases(mssql,mysql,sqlite and ...) is same.
just when use prepare parameter in b4a is problem

 

[sorex]

use quote according to field's type In all databases(mssql,mysql,sqlite and ...) is same.

with the exeption that SQLite only has text field types even when you select date or anything else in an sqlite editor.

 

[omidaghakhani1368]

with the exeption that SQLite only has text field types even when you select date or anything else in an sqlite editor.

let me to export project and attachment here