Problem with quoted identifiers

rbuser

I'm having a problem with creating new reports when I'm using an ODBC
connection that has quoted identifiers turned on. After setting up my
datatable, fields, and search field, I get the following error:

---------------------------
SQL
---------------------------
Invalid SQL statement.

Invalid field name.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'LBP'.
---------------------------
OK
---------------------------

When I look at the SQL, it shows the following:

SELECT tblPayment.PaymentID
FROM "tblPayment" tblPayment
WHERE ( tblPayment.Agency = "LBP" )

The problem is obviously the double quotes around the LBP. It seems that
ReportBuilder is mistaking the LBP for an object. Is this a bug? Turning
quoted identifiers off is NOT an option for this application. Reports that
were previously created still run, but trying to recreate these same reports
does not work.

Any suggestions?

nicocizik

Which version of Delphi/ReportBuilder are you using?

--

rbuser

We are currently using ReportBuilder 7.03

rbuser

Any suggestions at all? This is a major issue for our company right now, as
our customers cannot create reports for their data.

nicocizik

Hi Glenn,

Sorry about the delay in this response. I had to install SQL server to do
some testing before I could find the solution to the issue you were having.
It looks as though ReportBuilder only places double quotes around fields
when you are using the Local SQL setting. Try changing your SQL Type to SQL
2 and the problem should be resolved.

--

rbuser

Nick,

Your suggestion fixed the problem we were having. Thank you very much for
your help in figuring this out. It is extremely helpful for my company to
have this issue resolved.

Glenn Thimmes
New Dawn Technologies