Search results for query: *

During a larger procedure, I have a multi-select listbox that loads a list of flagged items. this list of flagged items needs to be looped twice to determine what is selected, and what is not selected and hopefully give me two SQL outputs on each pass; when selected, give me an in clause like...

I have a stupid calculated values question.. I know it's bad to store calculated values, but I have a need to. I have built an application in Delphi using access as the database that updates values in a record from a text file daily. Each row in the text file updates the database in the...

Can anybody help me change the following subquery into an unmatched query? The way I wrote it is taking 30+ seconds to run which is unacceptable SELECT tblZs.strZ, tblFS.strFS, tblZs.entID FROM tblZs INNER JOIN (tblA INNER JOIN tblFS ON tblA.aID = tblFSA.aID) ON tblZs.zoneID = tblA.zoneID...

Hello, Is there a way to change this query to also include the maximum ordered regardless of account for the selected date? I need to be able to reference the maximum value for the selected date in order to see if the work can be done for the day. For example, if a client ordered 10,000...

Hello, I need to export a dataset to a .txt file but am having issues using MaxComponents and Jedi components. Is there a simple way to export a dataset and get the string values to be quoted "" and the integers not? The problem I get with the above components is either everything is quoted...

I'm building an application that allows the user to select some or all of the provided values in a multiselect listbox. I now need to allow them to edit their choices at a later date, so I would like to do the following: - load the list box of choices - load the original selection(s) from...

I have created an application using Delphi 6 and Firebird. Everything works perfectly; records can be added and modified but there's a problem. When a user makes a change nobody else can see it until they exit and restart their copy. Why is this?

I have made a program that will enter information into a database and send out an email to a specific user. The user that gets the email must resolve the problem and reply back to a group, not the individual who sent it. This is a necessary step in case the original person who sent the email...