On Wed, 8 Apr 2020, Santiago A. via lazarus wrote:
Hello:
I have a TSQLQuery with a SQL string like this "select * from
manyFieldsTable" and I want to write a custom updateSQL, but I don't
want to start from scratch, from an empty script. I want to start from
the automatically generated updateSQL statement that TSQLQuery generates
when you leave the UpdateSQL script blank.
Is there any way I can get the automatically generated updateSQL
statement, edit it and set the UpdateSQL property?
I use the lazarus database desktop for this, it can generate such queries.
It should not be too hard to integrate the "generate SQL" dialog as a TSQLQuery
component editor dialog (it's been on my TODO list for very long...)
Michael.--
___
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
