Solved

Microsoft query

Posted on 2000-04-17
7
199 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
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…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

773 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