I have a custom report that uses a temp table defined like a database table that is receiving this error:
** temp_ld_det already exists with 0. (132).
It seems that since our last upgrade, QAD has added an index to that table which is causing the issue. Is there a way for me to exclude this index from being inherited by the temp table? I've seen that I could have the temp table use only one index but it seems to be preferred that we leave all others in place and just exclude the one. I thought I had seen something about a field exception list? Maybe I'm wrong or I just didn't have the syntax correct. I'm pretty new to QAD and Progress so any guidance would be appreciated.
** temp_ld_det already exists with 0. (132).
It seems that since our last upgrade, QAD has added an index to that table which is causing the issue. Is there a way for me to exclude this index from being inherited by the temp table? I've seen that I could have the temp table use only one index but it seems to be preferred that we leave all others in place and just exclude the one. I thought I had seen something about a field exception list? Maybe I'm wrong or I just didn't have the syntax correct. I'm pretty new to QAD and Progress so any guidance would be appreciated.