Solved

Microsoft query

Posted on 2000-04-17
7
212 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

This article will show, step by step, how to integrate R code into a R Sweave document
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

705 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