Sign in Join

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

Mailing lists / lazarus / 2020-04

Generate InsertSQL, UpdateSQL, DeleteSQL

2 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

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

Santiago A.

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.

Reply by email

Michael Van Canneyt
to Santiago A.
Santiago A. wrote 10 lines
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.

Reply by email