Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Longint vs Int

rbuserrbuser
edited July 2005 in End User
Delphi 7 + RB 7.02 Ent. (End User interfase using Report
Explorer)+ADO+SQLServer

I'm trying to establish Master-Detail relationship between 2 querys. The
problem is that one field, that is created as int in the SQLServer database,
is reported by ReportBuilder as LongInt, the corresponding field in the
other query is correctly reported as Integer, the problem is that I can't
establish the link because the field types are different and it is not
availible in the list for fileds to be linked

Thanks in advance

Eduardo Martinez O.

Comments

  • nardmoseleynardmoseley
    edited July 2005

    Email info@digital-metaphors.com with your serial number and registration
    infor. Request the download info for RB 7.04, the last produced release for
    RB 7.x. Try the same test using RB 7.04.

    If you connect a Delphi dataset to the tables, what is the TFieldType that
    is created for those fields? ReportBuilder translates the TFieldType to a
    TppDataType. See ppDBPipe.pas, the function ppConvertFieldType. You can
    modify your library path to RBuilder\Source and trace this method.

    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.