Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2020-04

TSQLQuery component editor

3 messages · 3 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Michael Van Canneyt

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.

Reply by email

Salvatore Coppola
to Michael Van Canneyt: I've enhanced the TSQLQuery component editor in the IDE somewhat. For starters, it now…

Thanks prof.

⁣Ottieni BlueMail per Android ​

Il giorno 30 Apr 2020, 16:07, alle ore 16:07, Michael Van Canneyt via lazarus ha scritto:

Show quoted text 39 lines
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 https://lists.lazarus-ide.org/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20200430/b82a10c3/attachment.html>

Reply by email