Solved

Microsoft query

Posted on 2000-04-17
7
202 Views
Last Modified: 2010-04-16
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
Comment
Question by:missa
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 2728550
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
 

Author Comment

by:missa
ID: 2730449
Edited text of question.
0
 
LVL 24

Expert Comment

by:SunBow
ID: 2739363
listening...
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Accepted Solution

by:
lgmm earned 5 total points
ID: 2744292
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
 
LVL 54

Expert Comment

by:nico5038
ID: 2744368
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
 

Author Comment

by:missa
ID: 2748922
It worked !!! is there a manual where I could dig these SQL statements to use ??? Please advise
0
 

Expert Comment

by:lgmm
ID: 2748951
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
index Out OF Range Exception error 4 69
What are programming codes and how do they work? 7 103
ASP/VB email question 4 46
youtube blocking politics 4 55
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question