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

rbuser

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

nardmoseley

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