Recent

Author Topic: bluck insert on memory table  (Read 581 times)

Packs

  • Sr. Member
  • ****
  • Posts: 368
bluck insert on memory table
« on: November 11, 2024, 07:33:05 pm »
bluck insert on memory table

jamie

  • Hero Member
  • *****
  • Posts: 6735
Re: bluck insert on memory table
« Reply #1 on: November 11, 2024, 11:03:07 pm »
bluck insert on memory table

Do you mean "bulk" insert of memory?
The only true wisdom is knowing you know nothing

carl_caulkett

  • Hero Member
  • *****
  • Posts: 649
Re: bluck insert on memory table
« Reply #2 on: November 11, 2024, 11:10:38 pm »
bluck insert on memory table

Do you mean "bulk" insert of memory?

It could be "block" insert of memory... 🤔

@Packs we need some clarification  ;)
"It builds... ship it!"

Packs

  • Sr. Member
  • ****
  • Posts: 368
Re: bluck insert on memory table
« Reply #3 on: November 12, 2024, 05:10:00 am »
I want to insert bulk records to memdatset.

Not by using append and post.

By using record and array can I insert batch wise data

Zvoni

  • Hero Member
  • *****
  • Posts: 2741
Re: bluck insert on memory table
« Reply #4 on: November 12, 2024, 08:51:04 am »
I want to insert bulk records to memdatset.

Not by using append and post.

By using record and array can I insert batch wise data
As far as i can see it only per LoadFromStream
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

Packs

  • Sr. Member
  • ****
  • Posts: 368
Re: bluck insert on memory table
« Reply #5 on: November 12, 2024, 10:25:37 am »
Loadfromstream is having particular pattern like CSV.

Do you have any sample code


Zvoni

  • Hero Member
  • *****
  • Posts: 2741
Re: bluck insert on memory table
« Reply #6 on: November 12, 2024, 10:34:26 am »
Loadfromstream is having particular pattern like CSV.

Do you have any sample code
No, since i don't use MemDataSet.
I just looked at the available Methods of TMemDataset

If i have to do anything InMemory, i use SQLite. And there i can use Bulk insert via SQL
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

Packs

  • Sr. Member
  • ****
  • Posts: 368
Re: bluck insert on memory table
« Reply #7 on: November 12, 2024, 10:43:28 am »
Ok sir 👍 thank you

 

TinyPortal © 2005-2018