On delete

[naresh kumar]

Can any one pls help on this below error, if single record delete no error if record having child record it troughing error.

Error Message

General Data Exception detected by database ((conn=233210) Out of range value for column 'number' at row 1)

[Chetna_dev]

The error message you're encountering—"Out of range value for column 'number' at row 1"—typically indicates that there's an attempt to insert or update a value in the database that exceeds the allowed range for the number column in the table. This often occurs when dealing with records that have child records. So Ensure that deleting the parent record does not violate any referential integrity constraints. If child records depend on the parent record, the database might prevent the deletion.

if you found this helpful please accept as solution and mark helpful

best

Chetna

[naresh kumar]

The problem is dev instance it is working, but moved to the next instance it's not working. why the issue is arising any idea? pls let me know. 

[Sanjay191]

Cause 1: If the table from which you're trying to delete a record has a foreign key constraint, the database might prevent deletion because the record is being referenced in another table.

Cause 2 : please check is there any before BR that prevent this record to delete.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thank You