Recent

Author Topic: TBatchMove alternative for Lazarus?  (Read 2096 times)

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
TBatchMove alternative for Lazarus?
« on: November 13, 2017, 10:20:48 am »
Is there any Delphi TBatchMove component alternative for Lazarus?

tudi_x

  • Hero Member
  • *****
  • Posts: 532
Re: TBatchMove alternative for Lazarus?
« Reply #1 on: November 13, 2017, 10:55:41 am »
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.
« Last Edit: November 13, 2017, 11:10:16 am by tudi_x »
Lazarus 2.0.2 64b on Debian LXDE 10

Thaddy

  • Hero Member
  • *****
  • Posts: 14205
  • Probably until I exterminate Putin.
Re: TBatchMove alternative for Lazarus?
« Reply #2 on: November 13, 2017, 11:25:12 am »
I agree it should be done in SQL (maybe wrapped into a component) but the link gives me this:
Specialize a type, not a var.

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: TBatchMove alternative for Lazarus?
« Reply #3 on: November 13, 2017, 11:29:05 am »
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?

 

TinyPortal © 2005-2018