AnsweredAssumed Answered

Formula for maintaining referential integrity with Execute SQL

Question asked by learner on Dec 16, 2013
Latest reply on Dec 22, 2013 by Oliver_Reid



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,