Search results for query: *

Yeah, that would be the first thought, went down that road, the additional issue (which I did fail to mention) is that I have a TPlanner (From TMSSoftware) that is doing the update here, if I do a beforepost or beforeedit here, then it clears out the entire TPlanner item... I think that really...

I have a Tdataset named 'jobs'(ADO Connecting to Access) with the following fields: jobs.end_date (TDateTime) jobs.ship_date (TDateTime) I need a good way to validate that jobs.end_date is not greater than jobs.ship_date BEFORE posting the changes. I of course can check it in the beforeedit...

Ah thanks! I will look right into that!

Thanks Paul, in my original post I listed how the TPlanner from TMS wont do the job just as I need it. They don't have a Week or Period view that will "wrap" the dates onto a grid (i.e. 7 columns of 7 rows of cells). Their week and period view is Linear only, so 48 days would force...

Hello all. IN a bind with a production scheduler program I am working on. I am needing a Calendar or Planner component/suite that will display a date range within a grid i.e.: Sun Mon Tue Wed Thur Fri Sat 1 2 3 4 5 6 7 8 9 10 11 etc... I need this to be...

Thats pretty much what I ended up doing with this project. The software passed the Beta test last month, and is now in production. We got the entire thing streamlined down to just 4 open queries at one time, and the entire processing takes only 3 monites. Thanks for the tips everyone! Brian

I would love to do it one worksheet at a time, but can't seem to do that, all worksheets are created at the time the file is created.

Does anyone think using an Array in this situation might work?

It's actually putting the data into the worksheet itself. I might take a look a VB to do some of it, I'm not 100% comfortable in VB, however, I'm comfortable in VS .NET using ASP.NET or C#, so I would imagine VB could be done easily. I'm thinking that I might want to look at creating String...

I have thought about the load, and it's not pretty. Here is the basics of the app itself, and then you can see why I need them all open at the same time. I import about 135'ish excel spreadsheets into MS SQL. I then scrub, normalize, and perform some rules on the data. Finally I have to export...

I have a very fun and interesting little challange. Delphi 6.0 and MS Sql server using ADO for connection. I have 1 table called Import_Raw within this table there are about 250,000 records that are dumped in from an import of Excel spreadsheets. I perform several operations on the dataset...