Devart Forums

Hello,
I use dotConnect for PostgreSQL 5.80.332 with Postgres version 8.2 and 9.1

When I execute the following query, I have an error message.

UPDATE mytextfield=$$0000$$

Error Message :
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

But if I execute the same query with pgAdmin, I haven't problem.

Best Regards,

We could not reproduce the issue. A dollar-quoted string works fine with PostgreSQl 8.2 and 9.1 when used with dotConnect for PostgreSQL. Could you please post here the whole command text and DDL/DML scripts for reproducing the issue? We would also appreciate a small test project.

Hello,

You can use the demo for reproduce this problem.
Please find 2 screenshots, the both request are OK with pgAdmin




Best Regards

We still cannot reproduce the issue.
Please send us the DDL/DML scripts for your tables, so that we could use your queries.