Tab delimited text file as a database?

[backprop]

I see there is CSV, DBF, some fixed format database and similar, but is there a way to use tab delimited text file as a database and related DB components?

[wp]

I think you can use the TSDFDataset and set  its Delimiter to #9.

https://wiki.freepascal.org/TSdfDataSet
https://wiki.freepascal.org/CSV#SDFDataset

Be careful in reading because the latter wiki article also refers to the TFixedFormatDataset which has a different structure.

[backprop]

Thanks, it seems to works...

Additionally, I need that any change (after edit, insert and delete) be updated in the file. But I do not see commit method for dataset. Commit is only performed automatically on closing dataset.

[Thaddy]

DisableControls;
active:=false;
//sleep(10);
active:= true;
EnableControls;

But if TSDFDataset supports refresh, simply call refresh..
(I would use TCSVdataset, instead, that is much more complete)

[backprop]

You have no clue what I asked, thus do not bother...

DisableControls;
active:=false;
//sleep(10);
active:= true;
EnableControls;

But if TSDFDataset supports refresh, simply call refresh..
(I would use TCSVdataset, instead, that is much more complete)

[wp]

Would SDFDataset.SaveFileAs(filename) or .SaveToStream(stream) do?

[JanRoza]

You have no clue what I asked, thus do not bother...

That's a rather unfriendly reaction on a very sensible answer.
With that attitude I don't think you'll not get much help here.

[backprop]

That's a rather unfriendly reaction on a very sensible answer.
With that attitude I don't think you'll not get much help here.

He rudely insulted me many times all active members can recall that even these messages are deleted by moderator. What you will expect? To be polite with him?

He have no clue what I asked and certainly I have not asked him. His answer is useless, anyway.

[backprop]

Would SDFDataset.SaveFileAs(filename) or .SaveToStream(stream) do?

That should do it, if file itself if not protected for changing when opened. I will test, thank you.