Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Why is the table owner being placed in the SQL when using MSSQL?

edited June 2011 in General
We've hit a problem which appears to be down to a change in more
recent versions of RBuilder.

When designing a report against MSSQL server, with the DataSettings in
the designed set accordingly, the constructed SQL contains the table
owner, which is usually "dbo". So we end up with something like this:

...
FROM dbo.Table Table

Older versions of RBuilder don't appear to do this.

The problem is our software can use MSSQL or MSAccess and, when users
attempt to import reports which were designed against an MSSQL
database yet they're using MSAccess, the report fails to run as it's
trying to find a database called "dbo".

Any ideas why this is happening in later versions of RBuilder and how
we can disable this behaviour so the table owner isn't added to the
generated SQL?

--
Toby

Comments

  • edited June 2011

    The RB ADO plug-in has been enhanced to include the table schema name (i.e.
    table owner) and to include Views. This was done based on customer feedback.
    However, you can easily customize the RB ADO plug-in to not include the
    schema name. Open daADO.pas and modify the method
    TdaADOSession.GetTableNamesForConnection


    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.