TBatchMove alternative for Lazarus?
lazarus / 16-Databases

----------------------------------------------------------------------
tatamata · 2017-11-13 09:20

Is there any Delphi TBatchMove component alternative for Lazarus?

----------------------------------------------------------------------
tudi_x · 2017-11-13 09:55

http://edn.embarcadero.com/article/25620

i am not aware and would even suggest that embarcadero approach is
wrong in 2017.
no production DBA would allow this approach, instead use SQL for this!

this approach was mostly to support Interbase which did not have
proper SQL for many years.

----------------------------------------------------------------------
Thaddy · 2017-11-13 10:25

I agree it should be done in SQL (maybe wrapped into a component) but
the link gives me this:

----------------------------------------------------------------------
tatamata · 2017-11-13 10:29

I have reason why CREATE TABLE AS SELECT or SELECT..INTO is not
option.

How can I persist result of TSQLQuery into a database table, without
embedding CREATE TABLE AS ot SELECT INTO inside SQL statement?