[Lazarus] TSQLQuery component editor

Michael Van Canneyt michael at freepascal.org
Thu Apr 30 16:07:01 CEST 2020


Hi,

I've enhanced the TSQLQuery component editor in the IDE somewhat.

For starters, it now also shows the component editor menu items as TBufDataset
has (recently added). Which means you can save data to a file, for instance.
That's useful for preparing offline data.

Additionally, you can:

- Edit the SQL statement from within the component editor.
   (will work faster than looking for the SQL property in the OI)

- Generate the default Update/Delete/Insert SQL statements.
   These are the statements as the TSQLQuery component itself will generate them
   at runtime if you didn't specify any statements yourself.

   Note: Due to a bug in FPC 3.0.4, this will not always work.
   It always works with trunk, and once the fix is merged to 3.2, also with 3.2.

- There is now also a dialog to edit all SQL statements at once, and there is also a
   possiblity to let the IDE generate Update/Delete/Insert SQL statements
   based on a table name and a selection of fields.
   The format of the generated statement can be customized to some degree.

Enjoy!

Michael.


More information about the lazarus mailing list