Trim function does not exist anymore

giuliano · Post by **giuliano** » Tue 31 Jan 2012 10:35

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

Pinturiccio · Post by **Pinturiccio** » Wed 01 Feb 2012 13:28

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?

giuliano · Post by **giuliano** » Fri 03 Feb 2012 19:08

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

giuliano · Post by **giuliano** » Fri 03 Feb 2012 20:07

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

Pinturiccio · Post by **Pinturiccio** » Mon 06 Feb 2012 13:29

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

Pinturiccio · Post by **Pinturiccio** » Tue 07 Feb 2012 15:10

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.

Pinturiccio · Post by **Pinturiccio** » Fri 10 Feb 2012 12:45

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