[Lazarus] Generate InsertSQL, UpdateSQL, DeleteSQL

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

[Lazarus] Generate InsertSQL, UpdateSQL, DeleteSQL

Free Pascal - Lazarus mailing list
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?

--------
Saludos
Santiago A.

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

Re: [Lazarus] Generate InsertSQL, UpdateSQL, DeleteSQL

Free Pascal - Lazarus mailing list


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
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus