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

[Marcos Douglas]

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

Regards,
Marcos Douglas