ClientDataSet Data can't be updated to the server or even posted

0
votes

So , i'm creating a datasnap TCP/IP server multiitier data base in Delphi XE7, i used in the server a mssql Database then connected it used a datasetprovider

in the Client Side i made a sqlConnection for connecting to DataSnap Server then i used a dsproviderconnection then i used "ClientDataSet"

when i run the Client Application i will a serval rows and post the modifcation but if i desactivate the ClientDataSet then reactivate it the data will be lost

so help me please i cant see what is the probleme there no error or something like that?

and thank you

1
sql-serverdelphi
excuse me for the english – Mimo Parkour
The English is not the problem. You need to show some code. And if you're getting error messages, you need to state exactly what error you're getting. Edit your question and add a minimal reproducible example. But be aware that simply "positng modifications" is not enough to retain data in a client data set. That data is in memory only until you ApplyUpdates or do something else to persist it. – Disillusioned

1 Answers

0
votes

Either don't deactivate the ClientDataSet (the data will get lost as you found) or save the data to a file or stream and reload it afterwards (SaveToFile/Stream, LoadFromFile/Stream).