Hello Everyone,

I am trying to update a record in Valentina DB using the below.

Tbl = mDatabase.Table( "UserList" )
Tbl.RecID = ULSelectedID.ToInteger
Tbl.StringField(1).Value = ULSelectedID
Tbl.StringField(2).Value = UserListContainer1.ULUserNameTextField.Text
Tbl.StringField(3).Value = UserListContainer1.ULLastNameTextField.Text
Tbl.StringField(4).Value = UserListContainer1.ULLoginNameTextField.Text
Tbl.StringField(5).Value = UserListContainer1.ULPasswordTextField.Text
Tbl.StringField(6).Value = UserListContainer1.ULUserRolePopup.SelectedRowValue
Tbl.StringField(7).Value = ULStatus
Tbl.UpdateAllRecords

I wish to make use of the above for the below SQL equivalent statement

"UPDATE USERLIST SET USERNAME = :2, USERLASTNAME = :3, LOGINNAME = :4, PASSWORD = :5, USERROLE = :6, USERSTATUS = :7 WHERE ID = :1"

However, I am confused with how to use UpdateAllRecords statement to do the function as the UPDATE statement of SQL using Where.

In the above example, I want to update the Username, UserLastname, LoginName, Password, Userrole, UserStatus where ID is a specific selected ID stored in a variable ULSelected ID.

The database is having a table UserList with 7 columns, where first column is the USERID followed by Username, UserLastname, LoginName, Password, Userrole, UserStatus.

Please support. In the event, UpdateAllRecords API is unsuitable to do the above, please suggest some alternate method. I am programming in Xojo.