Error Following Upgrade to Latest Version

rbuser

Hello. We recently upgraded to 11.06 and have encountered the following
problem...

When we try to preview an existing report ... using the ppViewer, or
selecting the Preview tab in the ReportDesigner, we get the following error
message:

Unknown field type (23) encountered.

Any ideas what this means and how to fix it?

Thanks, Patrick

nicocizik

Hi Patrick,

This is not a known issue. Are you able to see this error in the Delphi
IDE? If so, try tracing into the RBuilder source and let me know exactly
where the issue is occuring. Also, try to simplify the report that has the
issue to find out which components/datafields are causing the problem.

--
Regards,

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

rbuser

Nico,

I've tracked it down to the SQL statement in the Query Designer. The
following SQL is what we have been using in this report.

SELECT sosCustomers.ItemID,
sosCustomers.DateEdited,
sosCustomers.DatePosted,
sosCustomers.Category, sosCustomers.Name,
sosCustomers.Company,
sosCustomers.BillAddrOne,
sosCustomers.BillAddrTwo,
sosCustomers.BillCity,
sosCustomers.BillCountyStateProvince,
sosCustomers.BillPostal,
sosCustomers.BillCountry,
sosCustomers.PhoneOne,
sosCustomers.PhoneTwo,
sosCustomers.EmailAddress,
sosCustomers.Memo,
sosCustomers.ShipAddrOne,
sosCustomers.ShipAddrTwo,
sosCustomers.ShipCity,
sosCustomers.ShipCountyStateProvince,
sosCustomers.ShipPostal,
sosCustomers.ShipCountry,
TRIM(Billcity)+', '+TRIM(Billcountystateprovince)+'
'+TRIM(Billpostal) AS TRIM_Billcity_TRIM_Billco,
TRIM(Shipcity)+', '+TRIM(Shipcountystateprovince)+'
'+TRIM(Shippostal) AS TRIM_Shipcity_TRIM_Shipco
FROM sosCustomers sosCustomers

If I remove the two (2) TRIM... statements, the report works as expected,
except we loose the content of the City, State Zip text.

This worked before we upgraded to v11.06.

Any ideas?

Thanks, Patrick

nicocizik

Hi Patrick,

Which database are you using? Are these fields with the TRIM function
declared as Calculated fields in the Query designer or are you entering the
SQL manually? If you take a look at the SQL that is generated by the Query
Designer, how is it different from the SQL generated in earlier versions of
ReportBuilder. If you were to enter this SQL into a TDataSet on a form, how
would it differ to give you a correct output?

--
Regards,

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

rbuser

Nico,

The "Version" property for TAdsTable components in this App and several
others, the value is 8.10 (ACE 9.10).

The TRIM statements were created on the Calc tab in the Query Designer. The
same TRIM statement used in another application does not throw an error and
the report(s) work as expected.

Patrick

nicocizik

Hi Patrick,

As a test, copy the SQL code generated by the Query Designer and try
executing it manually on your database (either using a simple Delphi app or
using the Advantage consol. I'm trying to find out if this is an issue with
the SQL generated or and internal issue with ReportBuilder.

--
Regards,

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

rbuser

Nico,

I ran the full SQL (listed below) in ARC and it worked fine ... I got a full
result set and the two TRIM statements provided expected results.

Patrick

nicocizik

Hi Patrick,

In my testing with RB 11.06 and ADS 9.1, I was able to successfully add
numerous fields with the TRIM function without any errors (similar to your
query). If possible, please send a simple example that demonstrates the
issue in RB 11.06 in .zip format to support@digital-metaphors.com so I can
try to recreate it on my machine. All I would need you to include as far as
data would be a sample .ADS file to connect to.

--
Regards,

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