• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Microsoft query

How do I do mass updates on a selected field in a table using MSQRY32 ?? Example: in my table I want to change the value of the field City_Name from "N.YORK" to "NEW YORK" in all the records without having to type it in for each record.
0
missa
Asked:
missa
  • 2
  • 2
  • 2
  • +1
1 Solution
 
nico5038Commented:
With an UPDATE query you always perform a mass update. You can fill a field with one value or get data from another table and update the field with that.

So what is it exactly you want to update?
0
 
missaAuthor Commented:
Edited text of question.
0
 
SunBowCommented:
listening...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
lgmmCommented:
use it

update table1 set city_name='New York'
where city_name='N.Y.'


it changes the value N.Y. for New York in the table1 in the field city_name
0
 
nico5038Commented:
The SQL is as Igmm suggests.
Using MSQRY32 you will have to be sure the query-type is set to update and the new fieldvalue to 'New York'.

However just paste the SQL in the SQL-part should show you how it looks "graphically".
0
 
missaAuthor Commented:
It worked !!! is there a manual where I could dig these SQL statements to use ??? Please advise
0
 
lgmmCommented:
a manual?????? mmm

maybe in a database book, that explaind you how it works or ina a database 4gl  manual book,

in all helps (F1) comes the select statememnts

update, delete
insert, etc etc.

      bye
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now