Recent content by VintageWine

Thanks majlumbo. For future readers the link recommends removing duplications in the path. This is what I did. -> Control Panel -> System -> Environment variables Deleted all Delphi related references (later had to put back "C:\Documents and Settings\All Users\Documents\RAD...

Thank-you DjangMan. The problem has just recurred and I have worked my way through all your suggestions, but regretfully none have fixed the problem. Interestingly computer has been on for about 24 hours (hibernating overnight). I started Delphi for the first time since the boot and...

Sometimes I get this error when compiling using Delphi 2010. Most of the time Delphi works fine. It tends to happen when Delphi has not been used for many hours (Delphi shut down). The only way I have found to fix is to restart the computer. Once the problem occurs it is not even possible to...

I agree with majlimbo: better to do this as a query on the database rather than load in a dataset and count in Delphi. However, if it has to be done in the database these suggestions may help. - Check for existence of blank strings in your data (a string consisting of a space is not a null)...

>We could insert the code above in a VCL form??? Yes. Place a TADOConnection on the form. The database can be created in many ways. For develop of teh database itself I usually use external tools like MySQL Query Browser rather than Delphi.

I went through this several years ago. I could not find a bug-free driver but settled on "MySQL ODBC 3.51 Driver" (free download from MySQL site if I remember correctly) as the best for my purposes. I am sure drivers will have improved, but recommend you thoroughly test any solution. All will...

Thanks for all your posts, appreciate the effort. I have a confession to make. My wife tried the replacement keyboard and reported "same problem", not myself. I tried it again today, and, errrm, that is the problem. Stars for those who were barking up the right tree.

>You seem to have narrowed it down to hardware, But the USB ports are working and the keyboard I am using to type this exhibits the same problem on that computer. >but you could also try booting to a linux live cd. Good idea - I'll try it

Thanks ettienne and chipk, The keyboard is USB. Other USB devices work (mouse and modem) and I have tried changing USB ports. There is no PS2 port. I cannot boot into safe mode or bios maintenance. Tried booting whist pressing F8 (safe mode), F2 (Bios) and DEL (Bios). From this I suspect...

A computer has developed really wierd behaviour. Whenever a key is pressed on the keyboard something odd happens, like a new window opening, as if some obscure function key had been pressed. The only key that works properly is the space bar. The only key I have found that will enter a...

Suggest look at inverted commas. The single inverted command between "select" and "EXEC" looks suspect.

I cannot give you a "this is it" answer, but can give you some directions to investigate. 1. Are you sure that "DataModuleFDD.ClientDataSetBATCHES.ChangeCount" is the line that is erroring. I suspect that it might be the ApplyUpdates(0) in the previous line. The Delphi debugger often...

This should fulfill your requirement: function SHCompleteProcess(const ACommandLine:string; var AExitCode:cardinal; AWaitInterval:dword=INFINITE):dword; var LProcessHandle:THandle; StartupInfo:TStartupInfo; ProcessInformation:TProcessInformation; begin {Initiate process}...

You could try the following. SELECT @Avg = AVG(A.Value) FROM ( SELECT D1.DateTime AS Start ,MIN(D2.DateTime) AS Finish FROM DiscreteHistory D1 JOIN DiscreteHistory D2 ON D2.TagName = D1.TagName AND D2.DateTime > D1.DateTime AND D2.Value = 0 WHERE D1.DateTime >= BeginDateID AND D1.DateTime <...

Dgillz, Please read books online for CREATE TRIGGER. Your code will update every record in the table where user_def_fld_2='Y', not only the record that has just been changed. You must use "Inserted" cursor to identify the changed records. To include test for null records: ........ AND...