Results 1 to 2 of 2

Thread: Editing Table Records Using ADO

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2000
    Posts
    70

    Cool

    What is the best way to edit table records. ie edit only, no add or delete.

    I have a table containing all records with an error in the resource code field of the record. All I want to be able to do is to allow the user to choose a valid resource code for each incorrect record?

    Any ideas on how this can best be acheived?

    Cheers

    Jonny

  2. #2
    Hyperactive Member
    Join Date
    Feb 2000
    Posts
    284
    Sql statement -

    Update tblSomething......Set ResourceCode = 'Whatever' ....Where....

    Something like that

Posting Permissions

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



Click Here to Expand Forum to Full Width