Error When Updating via Datagrid

[erickwidya]

hi all

i got this code that populate my datagrid

sSQL = "SELECT [Artikel], [HPP], [HPP_baru] FROM barang"
  
rsBrg.CursorLocation = adUseClient
rsBrg.Open sSQL, Conn, adOpenDynamic, adLockOptimistic
  
Set dgBarang.DataSource = rsBrg
dgBarang.Refresh

i set the AllowUpdate properties for the Datagrid to TRUE
when i changed the first column(Artikel) which is the PK, it went smooth..but when i changed the 2nd and 3rd column, an error raised

Row cannot be located for updating. Some values may have been changed since it was last read

anyone have any clues?

PS : the database is located at my local hard drive (for testing purpose), and the value doesn't changed by anyone

thanks

[dee-u]

Have you tried using adUseServer?

[erickwidya]

thx dee-u
adUseServer can't work when u want to populate Datagrid..it need 'Bookmarkable' which is from adUseClient

[dee-u]

Take a look at the attachment, it's working...

[erickwidya]

yes it can work from ur attachment..but i can't make it to work with mine

huaa..why..?
all i change without error just the PK Column
the code is pratically the same

thx for the attachment

[dee-u]

Try using adOpenStatic...

[erickwidya]

already try that..still can't work

[dee-u]

Try comparing the code in the attachment with your codes...

[erickwidya]

figure it out..

this because the datatype for the HPP, HPP_baru is Decimal
if i changed it to Long Int..it goes smooth..

have a clue how to do it via datagrid? otherwise i will 'force' using UPDATE query directly )

very22 annoying issue

[dee-u]

Well, I changed the field type of my example to decimal and still no issues...

[erickwidya]

try change the scale to 2