Page 1 of 1

Question about tpgquery sql.text property

Posted: Wed 04 Feb 2009 16:44
by snorkel
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

Posted: Mon 09 Feb 2009 11:37
by Challenger
If you pass this string through parameters, PgDAC will modify the string. If you specify it in SQL statememt ,PgDAC will not change it.