1 Reply Latest reply on Sep 7, 2010 10:56 AM by Joy Garon

    Linking to existing  database

    Alan Fredricsen
    Alan Fredricsen Sep 4, 2010 6:39 AM

      Hi

       

      I see from the documentation that EPDM only allows single-column card lists when looking up data from other databases - this seems rather crude and non-user friendly. Is it actually a problem in practice?

        • Re: Linking to existing  database
          Joy Garon
          Joy Garon Employee Sep 7, 2010 10:56 AM (in response to Alan Fredricsen)

          Hi Alan,

           

          It is usually not a problem as most times you are using the query to fill out the contents of a card variable.

          However, if you had a two databases columns and you would like to take the contents of both to fill out a single data card variable you might use concatentaion in the query.

           

          For example: let's say you has two columns FirstName and LastName and you wante to fill put a card variable ContactName

          SELECT FirstName + ' ' + LastName FROM tablename

           

          If however, you had a data card that had two card variables (FirstName and LastName) and you wanted a query to get the FirstName and the related last name, you would need to write an add-in (see sample below).epdmaddin.png

           

           

          Regards,

          Joy