Question about tpgquery sql.text property

snorkel · Post by **snorkel** » Wed 04 Feb 2009 16:44

Hi,
I remember it mentioned before that the tpgquery component would handle instances where a query might have a native pgslq cast i.e.
::text

I didn't have time to test this, but will it also handle strings that have \ (backslashes) in them?
Say I have a text field and I want to update it with a win32 file path, will the query component escape them for me?

Thanks,

Snorkel

Challenger · Post by **Challenger** » Mon 09 Feb 2009 11:37

If you pass this string through parameters, PgDAC will modify the string. If you specify it in SQL statememt ,PgDAC will not change it.