7 Replies Latest reply on Dec 22, 2013 2:09 PM by Oliver_Reid

    Formula for maintaining referential integrity with Execute SQL

    learner

      Hi,

       

      Does anyone know a good way to maintain referential integrity (i.e. can rename tables and fields without breaking the calculation) with an Execute SQL calculation? I suspect that it can be done with a Let.. calculation (letting the fm name of the field and table be equal to a constant and putting the constant into the Execute SQL function) but I haven't been able to make the syntax work. The question mark doesn't seem to work if you are trying to name the field and table that you want to search; but again, there may be a way to do it.

      Thank you in advance,

       

      John