Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update error (Access 2000)

    I am trying to convert the updtae query into a command but i get back the message that the query does not exist.What is syntax for this command ?. I am applying the attachement
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Update error (Access 2000)

    For a start you set SQL in code to the update query then try tp execute the contents of strSql which i dont think you have setup.

    I dont know what you are trying to accomplish, look at productid=10, there are 2 Order Details1 records which hold 46 and 58 as the quantity. Your query will update firstly the record with 46 then the record with 58, which is correct?

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update error (Access 2000)

    Oh yes, you are right ! Thank you for your remark, i see my error now

Posting Permissions

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