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

Michael Van Canneyt michael at freepascal.org
Tue Mar 20 20:00:13 CET 2012

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 compiled on Linux 64-bit, I don't have
>>> a working FPC/Lazarus 32-bit windows development environment currently.
>> I will do tests.
>> Thanks!
> I found a bug
> Consider the script:
> create table #t (id int, name varchar(60))
> If I execute:
> insert table #t values (1, 'john')  -------- OK
> If I execute:
> insert table #t (name) values ('john')  -------- ERROR

What is the error you get ?

Probably you need to quote name, as I imagine 'name' is a reserved word.


More information about the fpc-devel mailing list