I am using the following type of query with Delphi 5 on Windows 2000 Professional:
with Query1 do begin
with SQL do begin
Add('WHERE (myDatabase."Color" = :myParam)');
ParamByName('myParam').AsString := 'Blue';
The query has always worked fine in Delphi and also with Windows 95A, B, 98 and NT4.
But in Windows 2000 the query does not refresh. I must manually close and reopen the program to refresh. Has anybody else experienced this problem? Or am I missing something?
Any help or guidance would be greatly accepted.
Thanking you in advance,