Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-devel / 2014-11

Re: MS SQL tests: fix for string settings & invalid dates

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

JP Stolk

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?

Thanks in advance,

Jan-Pieter Stolk

Reply by email

Marcos Douglas
to JP Stolk
JP Stolk wrote 14 lines
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

Reply by email

Marcos Douglas
to Marcos Douglas
Marcos Douglas wrote 28 lines
On Mon, Nov 17, 2014 at 6:50 PM, JP Stolk 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

Reply by email

LacaK
to JP Stolk: I am struggeling with Lazarus and a connection to MSSQL server 2005. I get the data, but…

Hi,
try set PacketRecords=-1 in your TSQLQuery
-Laco.

Show quoted text 30 lines
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? Thanks in advance, Jan-Pieter Stolk ------------------------------------------------------------------------ _______________________________________________ fpc-devel maillist - http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel

Reply by email