TOraQuery SQL params with dot

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pantau
Posts: 1
Joined: Tue 12 Feb 2008 10:17

TOraQuery SQL params with dot

Post by pantau » Tue 12 Feb 2008 10:47

If any object of the TOraQuery has in SQL param(s) table's name separated with dot, the param's name is wrong in property params.
For exampe SQL:
select * from AAA where AAA.ID=:AAA.ID and AAA.Name=:AAA.Name
puts only one parameter with name AAA.
AAA is a simply table with two fields ID and NAME
How can I solve it? I need to use it with table name in param.
Thanks

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 12 Feb 2008 15:36

Names of parameters cannot contain dot symbol ".". However, to designate a table name in a parameter name you can use underscore symbol "_" instead.

Post Reply