Even if the Stonefield Query Performs Joins setting is False, there are times when Stonefield Query does queries against the individual tables needed for a report and then joins the result sets itself. For example, if the report includes tables from more than one database and those databases use different engines (for example, SQL Server and Oracle) or are on different servers, Stonefield Query retrieves the data for each table separately, then joins them into the final result set.

Stonefield Query normally uses case-sensitive joins when it joins tables. If you want to use case-insensitive joins instead, add CaseInsensitiveJoins=Y to an [Options] section in SFQuery.INI. For example:

[Options]
CaseInsensitiveJoins=Y

© Stonefield Software Inc., 2023 • Updated: 06/06/16
Comment or report problem with topic