• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • 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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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