Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: update the result of a query

    is there any way to update the result of a sql query???

    i tried the following statement but get the error message that i cannot update it..the query overview works with several left joins....therefore some fields are empty

    update overview
    Set overview.costs = 0
    Where overview.costs = "";


  2. #2
    Join Date
    Jul 2003
    I've never seen this done before. Why not just update the base table?

    Have you tried to update the query "manually" by opening the
    query Overview from the QBE grid? If you tried from there, you would
    at least see "This recordset is not updatable" in the status bar.

    Some things that would make a query not updatable:

    Using the aggregate functions,
    Using Select Distinct...

    Inspiration Through Fermentation

Posting Permissions

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