Android Question Update field in SQL

[John Sturt]

Hello
I am trying to update a Int field in a SQL database.
so far this is what i have
SQL.ExecnonQuery2("UPDATE TableName SET IntField = ?",Array As Int(NewValue))

Any help?
Many Thanks

 

[mangojack]

Do you get any error message ... ?

try ..

SQL.ExecNonQuery2("UPDATE TableName SET IntField = ?",Array As Object(NewValue))

 

[John Sturt]

Hi
I do not get any errors and have just run the code with Object instead of Int and no joy.

 

[mangojack]

With no error info it makes it hard .. How are you sure the field is not updating ?
can you upload project or at least some more code ..

 

[John Sturt]

Hi
The field is updating the problem is that all the Intfield are updating in the entire database.

 

[mangojack]

SQL.ExecNonQuery2("UPDATE TableName SET IntField = ? WHERE TheRecordID = 99",Array As Object(NewValue))

When do you wish a single record to be updated ... Need some more info / code