Devart Forums

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

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