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

[Marcos Douglas]

On Tue, Nov 18, 2014 at 8:56 AM, Marcos Douglas <md at delfire.net> wrote:
> 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

I mean: I *had* problems.

Marcos Douglas