Home DADE

Error Following Upgrade to Latest Version

edited October 2009 in DADE
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

Comments

  • edited October 2009
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2009
    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

  • edited December 2009
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2009
    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

  • edited December 2009
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2009
    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

  • edited December 2009
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.