FireDAC + TableNames with '$'

[weirdo12 16]

To summarize/simplify...

 

These work:

 

SELECT * FROM wares$rules "wares$rules$"

 

SELECT * FROM wares$rules WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "wares$$rules$$" WHERE fldidxwarerule = :dummy_string_param

 

But when there is more than one single $ in the table name and there is a parameter in the query it does not:

 

SELECT * FROM wares$rules "wares$rules$" WHERE fldidxwarerule = :dummy_string_param

 

[FireDAC][Phys][PG][libpq] ERROR: syntax error at or near ":"

Edited January 11, 2023 by weirdo12

[Squamis 0]

Just now, weirdo12 said:

To summarize/simplify...

You are completely right!

[weirdo12 16]

Just now, Squamis said:

You are completely right!

This might be of some help to Dmitry I suppose.

 

These also work:

 

SELECT * FROM wares$rules "wares$ rules$" WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "wares $ rules $" WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "$" WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "$$$$" WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "$ $" WHERE fldidxwarerule = :dummy_string_param

 

But these do not:

 

SELECT * FROM wares$rules "$$" WHERE fldidxwarerule = :dummy_string_param

 

SELECT * FROM wares$rules "$$$" WHERE fldidxwarerule = :dummy_string_param

[Lars Fosdal 1732]

Please enter a report in https://quality.embarcadero.com/secure/Dashboard.jspa

[weirdo12 16]

13 hours ago, Lars Fosdal said:

Please enter a report in https://quality.embarcadero.com/secure/Dashboard.jspa

Done.

 

https://quality.embarcadero.com/browse/RSP-40382

Edited January 12, 2023 by weirdo12

[Squamis 0]

1 hour ago, weirdo12 said:

Done.

Thanks

[Dmitry Arefiev 99]

Thanks, fixed.