Delphi Multitier can't update or delete
Posted on 2009-04-29
I have made a multitier client server application in Delphi2006, database sql server 2005. I used datasnap with socket connection and clientdataset, on the server I used adoconnection and adodataset.
My problem is that I can't delete or update records I can only insert, I press the delete button and apply updates but when I reopen the connection the record is still there same with update.
I have test it localy with adoconnection and adodataset and works means the sql server works correct.