Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-23 Thread michael . vancanneyt
On Fri, 23 Mar 2012, LacaK wrote: Michael, I updated patch for fcl-db test suite. See: http://bugs.freepascal.org/view.php?id=17303 Would you be so glad and will you apply them please ? Done, rev. 20572. As I wrote yesterday, I uploaded last patch for fcl-db test suite to http://bugs.f

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-23 Thread LacaK
Michael, I updated patch for fcl-db test suite. See: http://bugs.freepascal.org/view.php?id=17303 Would you be so glad and will you apply them please ? Done, rev. 20572. As I wrote yesterday, I uploaded last patch for fcl-db test suite to http://bugs.freepascal.org/view.php?id=17303 From

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-22 Thread LacaK
Michael, I updated patch for fcl-db test suite. See: http://bugs.freepascal.org/view.php?id=17303 Would you be so glad and will you apply them please ? Done, rev. 20572. Great! Sorry for the delay. It's Okay ;-) Now I have only 2 things: 1. question about packages/fcl-db/fpmake.pp ...

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-22 Thread Marcos Douglas
On Thu, Mar 22, 2012 at 10:46 AM, wrote: > > > On Thu, 22 Mar 2012, LacaK wrote: > >> >>> >>> And will you apply also diffs to fcl-db tests ? So we can run complete test suite ... >>> >>> >>> I will do so later today. >> >> Michael, >> I updated patch for fcl-db test suite. See: >>

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-22 Thread michael . vancanneyt
On Thu, 22 Mar 2012, LacaK wrote: And will you apply also diffs to fcl-db tests ? So we can run complete test suite ... I will do so later today. Michael, I updated patch for fcl-db test suite. See: http://bugs.freepascal.org/view.php?id=17303 Would you be so glad and will you appl

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-22 Thread LacaK
And will you apply also diffs to fcl-db tests ? So we can run complete test suite ... I will do so later today. Michael, I updated patch for fcl-db test suite. See: http://bugs.freepascal.org/view.php?id=17303 Would you be so glad and will you apply them please ? TIA -Laco. __

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread LacaK
Yes, of course... you're right. ;-)) If I find some problems I can post in bugtracker or still early to do this? IMO, You can post them also here. Once Michael commits changes to fcl-db test suite I will run complete test suite and if any problems appears I will resolve them ASAP. (

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread michael . vancanneyt
On Wed, 21 Mar 2012, Marcos Douglas wrote: On Wed, Mar 21, 2012 at 3:34 AM, LacaK wrote: create table #t (col1 int NULL, col2 varchar(60) NULL) (MS SQL Server nullability is controled by database setting "ANSI null default" so you can check this setting on your temp database also) L. Yes

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread Marcos Douglas
On Wed, Mar 21, 2012 at 5:01 AM, wrote: > > > On Tue, 20 Mar 2012, Marcos Douglas wrote: > >> On Tue, Mar 20, 2012 at 8:12 PM,   wrote: >>> >>> >>> >>> On Tue, 20 Mar 2012, Marcos Douglas wrote: >>> On Tue, Mar 20, 2012 at 6:59 PM, Michael Van Canneyt wrote: > > > > >>>

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread Marcos Douglas
On Wed, Mar 21, 2012 at 3:34 AM, LacaK wrote: > > > > No. > Anyway, I change the colum names (id,name to col1, col2) > The error is: > "Cannot insert the value NULL into column 'col', table tempdb.dbo.#t..." > > > This error has nothing to do with FPC or SQLDB. > > Your SQL statement is trying to

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread LacaK
Then I have minor comments: - in packages/dblib/fpmake.pp at line 23: Author put please instead of "Lacak2" "Ladislav Karrach" (as in dblib.pp header) - in packages/fcl-db/src/sqldb/mssql/makefile.fpc at line 2: change IBConnection to MSSQLConnection ;-) Done. Rev. 20540 and 20541. Now I fo

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-21 Thread michael . vancanneyt
On Tue, 20 Mar 2012, Marcos Douglas wrote: On Tue, Mar 20, 2012 at 8:12 PM, wrote: On Tue, 20 Mar 2012, Marcos Douglas wrote: On Tue, Mar 20, 2012 at 6:59 PM, Michael Van Canneyt wrote: On Tue, 20 Mar 2012, Marcos Douglas wrote: No. Anyway, I change the colum names (id,name to c

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread LacaK
No. Anyway, I change the colum names (id,name to col1, col2) The error is: "Cannot insert the value NULL into column 'col', table tempdb.dbo.#t..." This error has nothing to do with FPC or SQLDB. Your SQL statement is trying to insert NULL in a required field. No Michael, se

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Marcos Douglas
On Tue, Mar 20, 2012 at 8:12 PM, wrote: > > > On Tue, 20 Mar 2012, Marcos Douglas wrote: > >> On Tue, Mar 20, 2012 at 6:59 PM, Michael Van Canneyt >> wrote: >>> >>> >>> >>> On Tue, 20 Mar 2012, Marcos Douglas wrote: >>> No. Anyway, I change the colum names (id,name to col1, col2)

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread michael . vancanneyt
On Tue, 20 Mar 2012, Marcos Douglas wrote: On Tue, Mar 20, 2012 at 6:59 PM, Michael Van Canneyt wrote: On Tue, 20 Mar 2012, Marcos Douglas wrote: No. Anyway, I change the colum names (id,name to col1, col2) The error is: "Cannot insert the value NULL into column 'col', table tempdb.dbo.

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Marcos Douglas
On Tue, Mar 20, 2012 at 6:59 PM, Michael Van Canneyt wrote: > > > On Tue, 20 Mar 2012, Marcos Douglas wrote: > >> >> No. >> Anyway, I change the colum names (id,name to col1, col2) >> The error is: >> "Cannot insert the value NULL into column 'col', table tempdb.dbo.#t..." > > > This error has not

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Michael Van Canneyt
On Tue, 20 Mar 2012, Marcos Douglas wrote: No. Anyway, I change the colum names (id,name to col1, col2) The error is: "Cannot insert the value NULL into column 'col', table tempdb.dbo.#t..." This error has nothing to do with FPC or SQLDB. Your SQL statement is trying to insert NULL in a re

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread silvioprog
2012/3/20 Marcos Douglas : > On Tue, Mar 20, 2012 at 5:57 PM, silvioprog wrote: >> This error occurs to me too. Please see this video: >> >> http://silvioprog.com.br/video/bug/sqldb >> >> Lazarus 0.9.30.4 r35940 FPC 2.6.0 i386-win32-win32/win64 + openSUSE 12 >> / Windows 7 + PQConnection + Postgre

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Marcos Douglas
On Tue, Mar 20, 2012 at 5:57 PM, silvioprog wrote: > This error occurs to me too. Please see this video: > > http://silvioprog.com.br/video/bug/sqldb > > Lazarus 0.9.30.4 r35940 FPC 2.6.0 i386-win32-win32/win64 + openSUSE 12 > / Windows 7 + PQConnection + PostgreSQL 8.4. Silvio, Thanks for the vi

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread silvioprog
This error occurs to me too. Please see this video: http://silvioprog.com.br/video/bug/sqldb Lazarus 0.9.30.4 r35940 FPC 2.6.0 i386-win32-win32/win64 + openSUSE 12 / Windows 7 + PQConnection + PostgreSQL 8.4. -- Silvio Clécio Site - LazSolutions -

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Marcos Douglas
On Tue, Mar 20, 2012 at 4:00 PM, Michael Van Canneyt wrote: > > > On Tue, 20 Mar 2012, Marcos Douglas wrote: > > > Hi Michael, > Do you have some prediction to include the sources? My apologies, I had totally forgotten; I am buried in work currently.

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Michael Van Canneyt
On Tue, 20 Mar 2012, Marcos Douglas wrote: Hi Michael, Do you have some prediction to include the sources? My apologies, I had totally forgotten; I am buried in work currently. Committed in revision 20522. I didn't commit any examples or tests. Please test if everything works OK. I compi

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-20 Thread Marcos Douglas
On Fri, Mar 16, 2012 at 9:55 AM, Marcos Douglas wrote: > On Fri, Mar 16, 2012 at 5:40 AM,   wrote: >> >> >> On Thu, 15 Mar 2012, Marcos Douglas wrote: >> >>> On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 5:08 AM,   wrote: > > > > On Mon,

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-19 Thread michael . vancanneyt
On Mon, 19 Mar 2012, LacaK wrote: Hi Michael, splitting files into two packages was unavoidable? Yes. As you can see for the other databases, we always keep the header imports separate from the components. Standard time-tested practice. Hm, although I am not happy with this, I can do

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-19 Thread LacaK
Hi Michael, splitting files into two packages was unavoidable? Yes. As you can see for the other databases, we always keep the header imports separate from the components. Standard time-tested practice. Hm, although I am not happy with this, I can do nothing with it ;-) Then I have minor

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-19 Thread michael . vancanneyt
On Mon, 19 Mar 2012, LacaK wrote: michael.vancann...@wisa.be wrote / napísal(a): On Thu, 15 Mar 2012, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 5:08 AM, wrote: On Mon, 27 Feb 2012, LacaK wrote: Hi, let me share same basi

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-19 Thread LacaK
michael.vancann...@wisa.be wrote / napísal(a): On Thu, 15 Mar 2012, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 5:08 AM, wrote: On Mon, 27 Feb 2012, LacaK wrote: Hi, let me share same basic info/ideas about TMSSQLConnection :

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-16 Thread Marcos Douglas
On Fri, Mar 16, 2012 at 5:40 AM, wrote: > > > On Thu, 15 Mar 2012, Marcos Douglas wrote: > >> On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: >>> >>> On Mon, Feb 27, 2012 at 5:08 AM,   wrote: On Mon, 27 Feb 2012, LacaK wrote: > Hi, > let me share same basi

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-16 Thread michael . vancanneyt
On Thu, 15 Mar 2012, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: On Mon, Feb 27, 2012 at 5:08 AM,   wrote: On Mon, 27 Feb 2012, LacaK wrote: Hi, let me share same basic info/ideas about TMSSQLConnection : 1. As Marcos wrote it is descendant of sql-db TSQ

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-03-15 Thread Marcos Douglas
On Mon, Feb 27, 2012 at 9:33 AM, Marcos Douglas wrote: > On Mon, Feb 27, 2012 at 5:08 AM,   wrote: >> >> >> On Mon, 27 Feb 2012, LacaK wrote: >> >>> Hi, >>> let me share same basic info/ideas about TMSSQLConnection : >>> 1. As Marcos wrote it is descendant of sql-db TSQLConnection class and >>> pr

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-02-27 Thread Marcos Douglas
On Mon, Feb 27, 2012 at 5:08 AM, wrote: > > > On Mon, 27 Feb 2012, LacaK wrote: > >> Hi, >> let me share same basic info/ideas about TMSSQLConnection : >> 1. As Marcos wrote it is descendant of sql-db TSQLConnection class and >> provides native connector for MS SQL Servers and Sybase servers >> 2

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-02-27 Thread michael . vancanneyt
On Mon, 27 Feb 2012, LacaK wrote: Hi, let me share same basic info/ideas about TMSSQLConnection : 1. As Marcos wrote it is descendant of sql-db TSQLConnection class and provides native connector for MS SQL Servers and Sybase servers 2. is depends/requires on FreeTDS open-source cross platform

Re: [fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-02-27 Thread LacaK
Hi, let me share same basic info/ideas about TMSSQLConnection : 1. As Marcos wrote it is descendant of sql-db TSQLConnection class and provides native connector for MS SQL Servers and Sybase servers 2. is depends/requires on FreeTDS open-source cross platform DB-Library (alternatively can be use

[fpc-devel] TMSSQLConnection - sqlDB component for accessing MS SQL Server

2012-02-23 Thread Marcos Douglas
Hi, As you can see here http://bugs.freepascal.org/view.php?id=17303 the developer known to LacaK developed a new connector for MSSQLServer, descendant of TSQLConnection class, and sent the beta code in 2010-08-30. Some developers discussed the new code here: http://lazarus.freepascal.org/index.p