How to replace the editor for the CommandText property when CommandType = cmdText or cmdUnknown, with the regular strings editor
I've just added an entry to CodeCentral, which is an IDE package that replaces the editor for the CommandText property when CommandType = cmdText or cmdUnknown, with the regular strings editor.
The default editor for the CommandText property in TADODataset (and other data components) when the CommandType is cmdText or cmdUnknown, can be a bit cumbersome to use. By installing the IDE package, the default editor is overridden with the regular strings editor for TADODataset, although you can add your own calls to register the same property editor for other components, such as TSQLDataset (from dbExpress).
You can find the CodeCentral entry here.
Since I have published this blog entry, I've discovered there is a problem with saving the CommandText using the “Code Editor” option, and have updated the CodeCentral files accordingly. I'm investigating...