Android Question Update field in SQL

mangojack

Expert

Licensed User

Longtime User

• Aug 13, 2015

• #2

Do you get any error message ... ?

try ..

B4X:

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

 

Upvote 0

J

John Sturt

Active Member

Licensed User

Longtime User

• Aug 13, 2015

• #3

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

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Aug 13, 2015

• #4

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

 

Upvote 0

J

John Sturt

Active Member

Licensed User

Longtime User

• Aug 13, 2015

• #5

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

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Aug 13, 2015

• #6

B4X:

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

 

Upvote 0