Solved

Batch in Delphi

Posted on 1997-11-16
1
281 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 50 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month7 days, 8 hours left to enroll

632 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