Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by CharlesWright
-
BDE DataBase Access
Use a TSession component and attach all your TTable and TQuery components to it. It has a property called SqlHourGlass that is defined in the help as: Set SQLHourGlass to False if you do not want the mouse cursor to change to an hourglass while the BDE is waiting for an SQL server to perform...- CharlesWright
- Post #2
- Forum: Embarcadero: Delphi
-
Subtracting Time
My suggestion would be to convert the minutes into a standard Delphi Date/Time and then just subtract. To convert the minutes to a DateTime just divide the number of minutes by (60*24). i.e. function subtractMinutesFromDateTime(Time1 : TDateTime;Minutes : extended) : TDateTime; var...- CharlesWright
- Post #6
- Forum: Embarcadero: Delphi
-
Databases are just plain weird..
You say that it saves when you click on another cell. Are you clicking a cell on another row?. Changing rows in a dbGrid does an implicit post of the edited record. Closing a table doesn't.- CharlesWright
- Post #6
- Forum: Embarcadero: Delphi
-
start date from end date
Here is some code that will do that conversion. function SecondsBetweenDates(const StartDate, StopDate : TDateTime) : cardinal; const SecondsPerDay = 60 * 60 * 24; RoundFactor = 0.5; var DateDiff : TDateTime; begin DateDiff := StopDate - StartDate; result := trunc(DateDiff *...- CharlesWright
- Post #3
- Forum: Embarcadero: Delphi
-
Protecting Paradox tables from corruption
I've looked at the code for TTable and TQuery. Calling open sets active := true, calling close sets active := false. I don't see an advantage to calling close and open.- CharlesWright
- Post #3
- Forum: Embarcadero: Delphi
