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

Ambiguous Column Reference

rbuserrbuser
edited December 2006 in General
I am receiving the above error in a report that once worked.

AFAIK, nothing in the report has changed.

Ambiguous column reference; "SubId" memboer of SubsModels and Subdivisions.

I've never seen this error before, and of course the tables do share column names, but that has never been a problem before.

TIA,

John

Comments

  • nicociziknicocizik
    edited December 2006
    Hi John,

    Which version of ReportBuilder/Delphi are you currently using? Which
    database are you connecting to? Are you using DADE to create your queries?
    If you are not using DADE, be sure you define the table before the field
    name to aviod ambiguous field references... "Select SubsModels.SubId, ..."
    By default, DADE should do this for you.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited December 2006
    Nico,

    I'm using D2005, latest RB version.

    Yes, I'm using DADE. After reading your suggestions, I found that one of the linked tables had calculated fields of type
    expression which had been created somehow for the common field names. Their expression simply referenced the "subid"
    field without any kind of table prefix. I put a table prefix in and now all is well.

    Thanks very much for the help.

    John
This discussion has been closed.