Silly SQL

Hi Matt – this means that your test customers are referenced in T_LIST_CONTENTS.  Records cannot be deleted from T_CUSTOMER if they are referenced elsewhere (including tables like T_ADDRESS, TX_CUST_SAL, etc…)

--Matt

I imported a hundred or so records into TEST and have no further use for them.  However, when I try to delete them, I get the following message:

The DELETE statement conflicted with the REFERENCE constraint "FK_T_LIST_CONTENTS_T_CUSTOMER".

Any idea as to what the actually means (and, more importantly, how to resolve it)?  It's not a table, though it looks like one.

BONUS BREAKFAST TRIVIA: Watching TV uses up 50 percent more calories than sleeping.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Matt,

I think its because they are part of a list that someone has created. Once you delete the list it should be fine.

Gary

I imported a hundred or so records into TEST and have no further use for them.  However, when I try to delete them, I get the following message:

The DELETE statement conflicted with the REFERENCE constraint "FK_T_LIST_CONTENTS_T_CUSTOMER".

Any idea as to what the actually means (and, more importantly, how to resolve it)?  It's not a table, though it looks like one.

BONUS BREAKFAST TRIVIA: Watching TV uses up 50 percent more calories than sleeping.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!