Trim function does not exist anymore

Trim function does not exist anymore

Postby 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
giuliano
 
Posts: 24
Joined: Mon 18 Oct 2010 12:59

Postby 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?
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Postby 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
 
Posts: 24
Joined: Mon 18 Oct 2010 12:59

Postby 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
giuliano
 
Posts: 24
Joined: Mon 18 Oct 2010 12:59

Postby 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
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Postby 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
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Postby 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
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal