The dataview and SQL field aliasing.

rbuser

Hi there

I see when I construct a dataview with the Query Wizard that if a field name
has a space in it or it is too many characters it will alias the field in
the SQL eg

SELECT tablename."field name"
FROM tablename tablename

becomes

SELECT tablename."field name" field_name
FROM tablename tablename

However, I am using PostgreSQL and the syntax for field aliasing is
actually:

SELECT tablename."field name" AS field_name
FROM tablename tablename

Is there a way to control how this works? We are currently testing this on
Report Builder 10 demo, so I have no way of seeing the source on how this
works.

Thanks in advance.
Shaine

nardmoseley

That is a simple mod. If you purchase the registered version we can send you
a patch (and this will be fixed for the next maintenance relaease). Email
support@digital-metaphors.com if you need a patch. Include your serial
number (sorry we cannot patch a trial version.)

rbuser

Ahh that is great news.

BTW I forgot to mention that even though we use PostgreSQL we actually use
kbmMW as the interface to the postgres db.

If I am correct, this sets the database type as other.

Will this be a problem?

Thanks again
Shaine

nardmoseley

I think the database type needs to be set PostgreSQL. I assume that the SQL
that is generated will be submitted to the PostgreSQL engine.

rbuser

yup

got the patch, set my database type to Postgres and all works well.

Thanks again

nardmoseley

Great to hear