[fpc-devel] MS SQL tests: fix for string settings & invalid dates

Marcos Douglas md at delfire.net
Tue Nov 18 12:56:22 CET 2014

On Mon, Nov 17, 2014 at 6:50 PM, JP Stolk <jpstolk at 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

Marcos Douglas

More information about the fpc-devel mailing list