Hard coded schema name

rbuser

We have RB 11.07 and when we create a report with a data view, the generated
SQL contains the schema name that it is created with. We have a situation
that a schema name for a customer database is different from the one that is
designed. Is there anything we can do about this?

Here is the example:

SELECT ABBREV.ABBREVIATION, ABBREV.ABBREVID,
ABBREV.FULLTERM, ABBREV.ISACTIVE,
ABBREV.MODIFY_DATE, ABBREV.MODIFY_USERID,
ABBREV.YES
FROM dbo.ABBREV ABBREV

Thanks,
Shoji Kaburagi
Netsmart Technologies, Inc.

nicocizik

Hi Shoji,

Once the QueryDataView has been created, the SQL is saved down with the
template. One option is to create these queries on the fly using the
SQLBuilder class. Another would be to manually alter the template source to
reflect the different schema name (Find/Replace).

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks. That does it.

Shoji