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

[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 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.

Michael.