Results 1 to 11 of 11

Thread: Error When Updating via Datagrid

Threaded View

  1. Aug 10th, 2005, 11:03 PM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Error When Updating via Datagrid

    hi all

    i got this code that populate my datagrid
    VB Code:
    1. sSQL = "SELECT [Artikel], [HPP], [HPP_baru] FROM barang"

    2.   

    3. rsBrg.CursorLocation = adUseClient

    4. rsBrg.Open sSQL, Conn, adOpenDynamic, adLockOptimistic

    5.   

    6. Set dgBarang.DataSource = rsBrg

    7. 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
    Last edited by erickwidya; Aug 10th, 2005 at 11:08 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width