Re: [Lazarus] TSQLQuery component editor

2020-04-30 Thread Salvatore Coppola via lazarus 
Thanks prof.

⁣Ottieni BlueMail per Android ​

Il giorno 30 Apr 2020, 16:07, alle ore 16:07, Michael Van Canneyt via lazarus 
 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
>lazarus@lists.lazarus-ide.org
>https://lists.lazarus-ide.org/listinfo/lazarus
-- 
___
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

Re: [Lazarus] TSQLQuery component editor

2020-04-30 Thread Anthony Walter via lazarus 
Great! I'll test it out shortly. Thank you for enhancements :)
-- 
___
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

[Lazarus] TSQLQuery component editor

2020-04-30 Thread Michael Van Canneyt via lazarus 


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
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus