Search results for query: *

I can't figure out how to edit or delete my post, so I will carry it on with an update: Ignore the code in my original question, the below code is better and is almost working. It's just not giving me what's not selected. Can anybody help finish this simple yet somehow tedious task...

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...

Fair question. In my original example, truck 99 is the right row, so my append query into the temp table rolls up the various trucks in the area into 99, then after updating all of them to 0, I update truck 99 with the total

PHV: sorry, tblTruck is related via areaID which I forgot. SkipVought: That's just it, I don't know what the previous rows are except that they can be grouped by the areaID. Each area has a different amount of trucks. Think of an area like a city; New York is much bigger than Great Falls, thus...

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...

Wow.. thanks for the quick response. It works great; I plugged it into my code and the listbox is now populating immediately. Thank you very much!

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...

Forget it.. I got it. The subquery was returning more than one result and fixing your subquery to sort by specsID descending as well did the trick. Thank you very much!! Development can now continue.

Thank you but unfortunately it does not. I get the error message 'At most one record can be returned by this subquery'

If it helps anybody to help me, this is the query I would pull to get the maximum booked for the day. Having specsID in the group by assures me I will only get 1 result. SELECT TOP 1 Sum(tblHistory.lngQty) AS MaxOrdered, tblSpecs.specsID, tblSpecs.dtmDist FROM (tblAccounts INNER...

Sort of... I want to show the maximum ordered for any given day regardless of which client ordered it. Example - Client A orders 50,000 pieces - Client B orders 25,000 pieces - Client C orders 30,000 pieces If all these pieces are put together and distributed at the same time, there...

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...

sorry.. yes I have declared i as an integer

Thanks for the answers.. I have values a through p stored in a database and loaded into a multiselect listbox for the user to select as many as they would like. When the data is saved, I store the selections in a different table to be worked by other users at a later date. However, the order...

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...

Thanks for the replies. aaronjme - There doesn't appear to be a refresh command for firebird that I can find. I tried connDB.Refresh but it wasn't recognized. roo0047 - Yes, firebird needs a commit after each post, and according to the SQL Monitor it does; it always shows XACT: Commit when I...

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?

Would that work in an exchange environment? I have different code working by calling outlook, but I get that stupid security warning every time an email goes out, so I decided to try mapi

Agreed. So does anybody know how to add a reply-to to that code? I've googled it and find nothing. Maybe my keywords are wrong though