Re: [MSEide-MSEgui-talk] BufDataSet, tmsesqlquery

2019-09-26 Thread fredvs
Re-hello Med. It seems that it is a common problem with lot of databases: https://forum.lazarus.freepascal.org/index.php?topic=25153.0 https://stackoverflow.com/questions/7671205/statusfilter-on-clientdataset Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/

Re: [MSEide-MSEgui-talk] BufDataSet, tmsesqlquery

2019-09-26 Thread fredvs
Hello Med. > Try to test my prj OK, I did it. Hum, indeed, with your wishes, there should be a option in the navigator to only "mark as deleted" a row in the db-grid. (and not delete the row completely). But because Martin did add "updatestatus = usDeleted", sure there must be a trick to no

Re: [MSEide-MSEgui-talk] BufDataSet, tmsesqlquery

2019-09-26 Thread mohamed hamza
Hello Fred, There is some code concerned in msebufdataset also. Try to test my prj Ex: Insert applyUpdate then editapplyUpdate delete to see the result. You can also use cancelupdate, the project is attached. Thank you for trying to help Med. NB:There are some comments in

Re: [MSEide-MSEgui-talk] BufDataSet, tmsesqlquery

2019-09-26 Thread fredvs
Re-hello Med. Like explained earlier, I did not jump into mse-db yet. But if you add, in attachment, a simple example of what you want to show, it would be much easier for me to investigate. Fe;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/

Re: [MSEide-MSEgui-talk] BufDataSet, tmsesqlquery

2019-09-26 Thread fredvs
Hello Med. > usDeleted: sender.rowcolorstate[arow]:= 2; <-- no break here > when I delete record ? What fpc version are you using? Do you have problems with fpc 3.0.2 / 3.0.4 too ? After a quick investigation, "usDeleted" is defined in