Using SQL 'Like' Conditions in TDataset Filters

In Delphi, you can emulate an SQL LIKE condition using a TDataset Filter by using an asterisk wildcard characters. For example:

SQL -- WHERE FirstName Like %JOHN% (will return JOHN and JOHNNY)
Filter -- Firstname = '*JOHN*'

Delphi 2007 Installation Problems

If you're having any one (or all) of the following issues while attempting to uninstall, reinstall, repair, modify or upgrade your Delphi 2007 installation

'A network error occurred while attempting to read from the file
c:\windows\installer\setup.msi'

'Unable to uninstall old version of RAD Studio. Please
uninstall it yourself using the Control Panel Add-Remove Programs before
attempting to install this product again. Fatal error during installation.'

'HAS_SLIP' error just as you load the installer.

You probably need to uninstall your current installation entirely before attempting to reinstall. Refer to the CodeGear artice here. You will need to download the Microsoft MSI Cleanup Utility and remove 'Rad Studio 5.0'. You should also delete Program Files\CodeGear\RAD Studio\5.0 directory.

Good luck.

landed.