Devart Forums

I'm getting an error everytime I try to use the TRIM function after the new build was released.
To reproduce the issue, just try to use the TRIM function in the Query Builder of the DataSet.

Regards,
Giuliano Medina

Could you please specify the following:
1. What provider do you use with dotConnect Universal?
2. Query text, which invokes the Exception;
3. The exception text;
4. The actions that cause the exception. Which button and in which window do you click for invoking the issue?

1. I use the dotConnect Universal with the PostgreSQL provider;

2. Something like "SELECT TRIM(name) AS name FROM client";

3. I can't get the StackTrace, because the exception occurs while creating the Query, but the message is "The TRIM function does not exist.";

4. Steps to reproduce the exception

4.1 Create a new query in the TableAdapter;

4.2 Click the button named "Query Builder";

4.3 After creating the query with the TRIM function, click the the "Execute Query" button;

I hope this helps you to reproduce the issue.

Regards,
Giuliano Medina

1. I use the dotConnect Universal with the PostgreSQL provider;

2. Something like "SELECT TRIM(name) AS name FROM client";

3. I can't get the StackTrace, because the exception occurs while creating the Query, but the message is "The TRIM function does not exist.";

4. Steps to reproduce the exception

4.1 Create a new query in the TableAdapter;

4.2 Click the button named "Query Builder";

4.3 After creating the query with the TRIM function, click the the "Execute Query" button;

I hope this helps you to reproduce the issue.

Regards,
Giuliano Medina

Thank you for your detailed report. We have reproduced the issue. We will investigate it and notify you about results as soon as possible.

We have fixed the bug with the Trim function in 'Query Builder' when working with PostgreSQL. We will post here when the corresponding build of dotConnect Universal is available for download.

The new build of dotConnect Universal 3.20.106 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23374