Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Batch in Delphi

Posted on 1997-11-16
1
Medium Priority
?
282 Views
Last Modified: 2010-04-04
What is the best way to perform a batch task in Delphi?
Let's say I have a DBFile in which I want to update all records matching a certain equation. (Salary between 10.000 and 20.000 or something like that)
0
Comment
Question by:lizzzard
[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
1 Comment
 

Accepted Solution

by:
cashew earned 150 total points
ID: 1350677
if you have Paradox, you can use the QBE to generate the "Changeto" query.  Pdox also lets you see the SQL if you want to cut-paste it directly into Delphi.

If you are just using delphi, then you will be performing an UPDATE query.  Without the DB layout or fields you want to change, it will be difficult to say just how to do it.  In any event, it sounds like the way to do it in Delphi would be to put a SQL component on the form where you need the action to be performed.  Or, you could place it on your DataModel, if you set one up for the project.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

721 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