edit table data with query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a simple select query to edit table data in an MS SQL database. I
would like to be able to change all of the fields to be modified then have
them update the table as the process works now. Any suggestions?
 
Karl, that is a solution I have considered but the table is in a dynamic
process while I am making the change and I wanted to try something different
if possible. I have looked at the Help file and Knowledge Base and really
can't tell if it is possible to keep a query from updating a record
automatically. That is what I would really like to do - update the records I
see on the screen and not perform an update until I had what I wanted, then
click "Refresh records" or something like that to implement the changes.
 
Karl, that is a solution I have considered but the table is in a dynamic
process while I am making the change and I wanted to try something different
if possible. I have looked at the Help file and Knowledge Base and really
can't tell if it is possible to keep a query from updating a record
automatically. That is what I would really like to do - update the records I
see on the screen and not perform an update until I had what I wanted, then
click "Refresh records" or something like that to implement the changes.
Click to expand...

Then your ONLY choice is to have a scratch table storing your changes.

A Query has no independent existance; it is NOT a separate set of
records, distinct from the table(s) which contitute the query. It's
just a way of viewing, selecting, and sorting the records in the
table. If you change the value in a Query, it IS the value in the
table that you're changing.

John W. Vinson[MVP]
 
What I do is to create a select query and use criteria for a narrow data set.
I review the data set manually and if all is ok I change it to an update
query and run.
I switch back to a select query and then change the criteria for the next
batch.
 
Thanks to both of you. I think this has me on a track that will do what I
need to do.

Stan
 
Back
Top