Uploaded image for project: 'WsSQL'
  1. WsSQL
  2. WSSQL-71

Join can cause merge of non-uniquely named fields

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Not specified
    • Resolution: Fixed
    • None
    • None
    • ECLEngine
    • None

    Description

      Joining two ECL datasets together will cause fields with the same to be merged into one common field in the resulting dataset.
      In order to avoid this, it might be necessary to fully qualify all fields based on their source file's name.

      e.g

      Tbl1RecDef := RECORD string15 firstname; string25 lastname; string15 middlename; string5 zip; string42 street; string20 city; string2 state; END;

      Tbl1DS := DATASET('~tutorial::rp::tutorialperson', Tbl1RecDef,FLAT);

      Tbl1RecDefQualified := RECORD
      string15 Tbl1__999__firstname := Tbl1RecDef.firstname;
      string25 Tbl1__999__lastname := Tbl1RecDef.lastname;
      string15 Tbl1__999__middlename := Tbl1RecDef.middlename;
      string5 Tbl1__999__zip := Tbl1RecDef.zip;
      string42 Tbl1__999__street := Tbl1RecDef.street;
      string20 Tbl1__999__city := Tbl1RecDef.city;
      string2 Tbl1__999__state := Tbl1RecDef.state;
      END;

      Attachments

        Activity

          People

            rpastrana Rodrigo Pastrana
            rpastrana Rodrigo Pastrana
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: