[Lazarus] TSQLQuery component editor

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Lazarus] TSQLQuery component editor

Free Pascal - Lazarus mailing list

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.
--
_______________________________________________
lazarus mailing list
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus
Reply | Threaded
Open this post in threaded view
|

Re: [Lazarus] TSQLQuery component editor

Free Pascal - Lazarus mailing list
Great! I'll test it out shortly. Thank you for enhancements :)

--
_______________________________________________
lazarus mailing list
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus
Reply | Threaded
Open this post in threaded view
|

Re: [Lazarus] TSQLQuery component editor

Free Pascal - Lazarus mailing list
In reply to this post by Free Pascal - Lazarus mailing list
Thanks prof.

Il giorno 30 Apr 2020, alle ore 16:07, Michael Van Canneyt via lazarus <[hidden email]> ha scritto:

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.

--
_______________________________________________
lazarus mailing list
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus