jlhardyman
IS-IT--Management
Hello,
I am trying to clean up our database and we have a lot of old menu items that haven't been used for years. I've tried to delete them, but some still get the error:
Key violation.
[Sybase][ODBC Driver][Adapative Server Anywhere]Primary key for row in table 'mi_def' is referenced by foreign key General SQL error.
'CF2DLY_SYS_MI_TTL' in table 'dly_sys_mi_ttl'
I checked the historical totals Classes tab and nothing is greater than 375 days. Is there another way to to purge this data or am I missing a step?
Thank you.
I am trying to clean up our database and we have a lot of old menu items that haven't been used for years. I've tried to delete them, but some still get the error:
Key violation.
[Sybase][ODBC Driver][Adapative Server Anywhere]Primary key for row in table 'mi_def' is referenced by foreign key General SQL error.
'CF2DLY_SYS_MI_TTL' in table 'dly_sys_mi_ttl'
I checked the historical totals Classes tab and nothing is greater than 375 days. Is there another way to to purge this data or am I missing a step?
Thank you.