DADE Plug-Ins for Report Builder

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yozey
Posts: 32
Joined: Sat 17 Jan 2009 14:41

DADE Plug-Ins for Report Builder

Post by yozey » Tue 20 Jan 2009 22:49

Has anybody written a plug-in for RB DADE?

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 21 Jan 2009 10:10

We are planning to add PgDAC components for Report Builder in one of the next PgDAC builds.

yozey
Posts: 32
Joined: Sat 17 Jan 2009 14:41

Post by yozey » Sat 24 Jan 2009 00:04

Ok I've successfully created some DADE components, however there is one issue that others will run into. Because DADE SQL builder does not wrap field or table names in double quotes ("), when you're using mixed case table and field names, the script will fail when sent to the server.

Just to let you know.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 26 Jan 2009 08:39

Thank you for information.

snorkel
Posts: 384
Joined: Tue 08 Aug 2006 15:10
Location: Milwaukee WI USA

Post by snorkel » Mon 26 Jan 2009 17:29

yozey wrote:Ok I've successfully created some DADE components, however there is one issue that others will run into. Because DADE SQL builder does not wrap field or table names in double quotes ("), when you're using mixed case table and field names, the script will fail when sent to the server.

Just to let you know.
Can't you set the query component used in the plugin to qoute names?
I would think that would take care of the issue.

Post Reply