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

2014-11-18 Thread LacaK
Hi, try set PacketRecords=-1 in your TSQLQuery -Laco. 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/03

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

2014-11-18 Thread Marcos Douglas
On Tue, Nov 18, 2014 at 8:56 AM, Marcos Douglas wrote: > 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 2001

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

2014-11-18 Thread Marcos Douglas
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-Ma

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

2014-11-18 Thread 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 app

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

2014-03-07 Thread Reinier Olislagers
On 07/03/2014 11:38, Reinier Olislagers wrote: > Ran dbtestframework on trunk, Windows x86 against MS SQL Server 2008R2 > (also earlier revision Linux x64 against MS SQL Server 2005) Sorry for the noise, yet another mail destined for the fpc db list...

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

2014-03-07 Thread Reinier Olislagers
Ran dbtestframework on trunk, Windows x86 against MS SQL Server 2008R2 (also earlier revision Linux x64 against MS SQL Server 2005) 1) Committed adding SET ANSI_PADDING to test setup http://msdn.microsoft.com/en-us/library/ms187403%28v=sql.105%29.aspx In fact, MS recommends this be always on and t