CopyFromDataSet
lazarus / 16-Databases

----------------------------------------------------------------------
egsuh · 2019-07-11 02:44

Hi,
I tried some mixes, and ..

    BufDataSet1.CopyFromDataSet(SQLQuery1);

works fine.


And either of followings do not work.

    SQLQuery1.CopyFromDataSet(BufDataSet1);
    SQLQuery1.CopyFromDataSet(SQLQuery2);

Is there any way that I can make any of the two, which does not work?
I'm writing a web server program, and the client has to download
dataset from server, do some work on the dataset, and send it back to
the server. The key is to use ApplyUpdates at the server side.

----------------------------------------------------------------------
mangakissa · 2019-07-11 06:52

I don't understand why you copy from SQLQuery to a bufdataset.
SQLQuery has a connection to the database. It's not logical to put
local data back to the 'server' if your client can do that.
It's better to use xml/json with tcpip to recieve/sent data to the
server. After that the server can save the data to the database.