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

    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 = "";

    thanx

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    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...

    Mark
    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
  •