On Mon, Nov 17, 2014 at 6:50 PM, JP Stolk <jpst...@stolkbv.nl> wrote: > > Hello, > > > > I am struggeling with Lazarus and a connection to MSSQL server 2005. > > I get the data, but when i change a fieldvalue, then apply updates, I get > the error 20019 like you listed: > http://lists.freepascal.org/fpc-devel/2014-March/033494.html > > When ik hit OK the update is not applied, when i apply updates again > immediately, then > the updates apply correctly, but the connection or the query closes. > > Is there a solution?
Could you send an example of your code? The problem could be transaction, PK do not exists or other thing. I work with MSSQL 2005~2008 without these problems. But, I have problems with Transactions because SQLdb works little different to Delphi so, I create a project, the Greyhound*, that works better for me. Maybe you shoud try. * https://github.com/mdbs99/Greyhound Regards, Marcos Douglas _______________________________________________ fpc-devel maillist - fpc-devel@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel