2. ASPRunnerPro General questions
  3. Where queries don't update
This topic is locked

Where queries don't update

 		12/5/2004 10:30:32 PM
ASPRunnerPro General questions
author

I have a number of where queries to select values from a master DB, but they don't update! Very frustrating. Any help on proper WHERE query syntax would be appreciated! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=953&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Sergey Kornilov admin 12/7/2004

Hi,
post a query with WHERE clause here along with error message that you getting.
Note: in most cases queries that pull data from two or more joined tables are not updatable because database engine (MS Access?) don't know which table to update.
501114 12/7/2004

I think I got it: "select from [Master2] where Status='Agriculture and Natural Resources Finance'"*
Sergey Kornilov admin 12/19/2004

Hi,
if you create a query in MS Access on thetop of this SQL statement it will be updatable.