in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

Difference between _contact1 and CONTACT1

Last post 01-31-2009 8:44 by admin. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 01-30-2009 20:05

    Difference between _contact1 and CONTACT1

    Please forgive this newbie question. When importing into GMPE 8.0 I notice that I can choose _contact1 or CONTACT1 from 'Select Tables to be mapped to'. What is the difference between these tables? Thank you kindly.

    Sue Burke/IT
    The JESUS Film Project
    www.JesusFilm.org
    Filed under:
  • 01-30-2009 21:00 In reply to

    Re: Difference between _contact1 and CONTACT1

    Hi Sue

    It is a fair question. The difference is that Inaport provides extensive business logic on the _contact1 table, but none on the CONTACT1 table. For example, Inaport will automatically populate the CREATEBY and CREATEDATE fields when _contact1 is used, but not if CONTACT1 is used.

    This difference is even more apparent when you look at tables such as _details and _email. These tables do not actually exist in a GoldMine database; they both map to the CONTSUPP table, but with very different business logic in place.

    The "raw" tables are left in place because there are rare circumstances where a user might want to avoid the business logic and do their own thing with the tables, but this then means they are responsible for ensuring that they maintain the business integrity of the data. This is not easy or for the faint of heart.

    So in summary, use the _xxx tables unles you *really* know what you are doing; and even then, ask twice whether you really need to go to the raw database.

    HTH

    Regards

    Admin

    Filed under:
  • 01-30-2009 22:52 In reply to

    Re: Difference between _contact1 and CONTACT1

    Thank for the explanation! Much appreciated!

    Sue Burke/IT
    The JESUS Film Project
    www.JesusFilm.org
  • 01-31-2009 8:44 In reply to

    Re: Difference between _contact1 and CONTACT1

    No problem

Page 1 of 1 (4 items)
InaPlex Limited 2011