[SOLVED] Can I edit TSQLQuery loaded from file or stream?
lazarus / 16-Databases

----------------------------------------------------------------------
egsuh · 2018-11-05 10:41

Hi,
As the title says, I cannot edit a TSQLQuery downloaded from web
server (via Synapse).

In my Windows application, I could restore the query from
SQLQuery1.LoadFromStream(AStream), and do other operations like first,
next, and read the content. But I could not edit it (it is readonly,
even though I never set it as readonly).

Any good idea on this? I'd like to download a subset of database
(Firebird currently), change it, and update them back to the original
database.

----------------------------------------------------------------------
mangakissa · 2018-11-05 14:30

But if you create a stream to load the query on your Windows
application, you can also do it with a stream from Synapse.

Why are you using a stream?

----------------------------------------------------------------------
sash · 2018-11-05 20:04

Since TSQLQuery is a TCustomBufDataset, you can save TSQLQuery to
stream/file and then load into TBufDataset, which will be editable
(however, if you need to apply changes back to database - it's up to
you).

This (TSQLQuery <->Synapse <-> Client with TBufDatasets) is exactly
how I'm using it as a 3-tired solution.

----------------------------------------------------------------------
valdir.marcos · 2018-11-05 23:15

Quote from: egsuh on November 05, 2018, 11:41:11 amAs the title says,
I cannot edit a TSQLQuery downloaded from web server (via Synapse).

In my Windows application, I could restore the query from
SQLQuery1.LoadFromStream(AStream), and do other operations like first,
next, and read the content. But I could not edit it (it is readonly,
even though I never set it as readonly).

Any good idea on this? I'd like to download a subset of database
(Firebird currently), change it, and update them back to the original
database.Have you tried REST Dataware components?

My New Project Lazarus REST/JSON Server/Client
http://forum.lazarus.freepascal.org/index.php/topic,36290.0.html

----------------------------------------------------------------------
egsuh · 2018-11-06 01:42

Quote you can also do it with a stream from Synapse.

Have you tried REST Dataware components?
Yes. I'm using Synapse, but I'd like to download a dataset from
webserver. I just use 'httpsend' from Synapse.
I know there are other technologies like REST or WebService Toolkit,
but for now using web server seems the best option, because I may need
a web-browser application later. Any suggestions or advises are
welcomed.

QuoteSince TSQLQuery is a TCustomBufDataset, you can save TSQLQuery to
stream/file and then load into TBufDataset, which will be editable
(however, if you need to apply changes back to database - it's up to
you).
Oh this is really good news (news? ^^).  Yes.. I can do without any
dataset running on client (e.g. using TStrings with
fieldname=fielddata) to upload the changed content, but I'm looking
for a neater solution and using TBufDataSet seems to be one.  Thank
you very much.