PostgreSQL views with single quotes in names

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jbakuwel
Posts: 35
Joined: Tue 02 Feb 2010 04:47

PostgreSQL views with single quotes in names

Post by jbakuwel » Fri 08 Oct 2010 06:17

Hi,

I'm having some trouble handling PostgreSQL views that contain single quotes, for instance "this is a 'quoted' query". I can retrieve the metadata OK (ie. the names of all views in the database), but as soon as I try to retrieve the definition (ie. the SQL statement), it seems I cannot pass the name of the query to the database without it being cut off at the first quote.

I'm escaping single quotes by replacing all single quotes with 2 single quotes.

Any suggestions?

kind regards,
Jan
Top
AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 08 Oct 2010 12:07

Hello,

We have reproduced the problem.
We will notify you as soon as we have any results.
Top
bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Wed 20 Oct 2010 08:27

Hello

We have fixed this bug. This fix will be included in the next PgDAC build.
Top
Post Reply

Return to “Universal Data Access Components”