Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Batch in Delphi

Posted on 1997-11-16
1
Medium Priority
?
283 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
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

Technology Partners: 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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 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