Parameters are incorrectly parsed when the parameter name contains a dot

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jgv
Posts: 12
Joined: Tue 18 Sep 2007 16:44

Parameters are incorrectly parsed when the parameter name contains a dot

Post by jgv » Mon 02 Jun 2008 14:09

There is a problem with parameters when a parameter name contains a dot.
For example:
select * from a where b = :my.dotted.name
will result to:
params[0].Name = my

Quoting the parameter doesn't help (whatever the quote char is even "[").
This is a quite urgent problem a lot of our code is based arround that.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 03 Jun 2008 16:18

I cannot reproduce this problem with the last build of SDAC (4.50.0.34) if the parameter name is quoted in this way:

Code: Select all

select * from a where b = :[my.dotted.name]
Could you check this issue with SDAC 4.50.0.34?

jgv
Posts: 12
Joined: Tue 18 Sep 2007 16:44

Post by jgv » Tue 03 Jun 2008 16:59

Thanks, I will check with that build.

Post Reply