[RESOLVED] Updated data is not showing using sql update query

[infomamun]

Hi si_the_geek

Sorry for misspelling of your name

Anyway, I can now update as follows:

with rsData
!(FieldName) = Control.Text
.Update
End with

And it is showing updated data while pressing Next or Previous Button. Actually I knew that. But as I was using LoadDatabase.Execute("Sql query") directly, I was unable to use '.Update' method, as I could not set locktype to adLockOptimistic.

However, is there any way to set locktype in my previous LoadDatabase.Execute("Sql query")? If can, then I can use '.Update' method to my previous code. I am seeking that because I have to recode the whole program using rsData.Open system.

Thanks