# Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?

Add, update and delete triggers are added to insert a record into a specific table.  The first thing the stored procedure checks if if the key is not found in the table then a records is is written to to a table. For some reason the record is not inserted.  This could be a Stored Procedure issue but I feel it is trigger related.

##### Post Metadata
- Posted at: almost 7 years ago
- Author title: Research and Development Manager
- Net upvotes: 1


## Comments
### Comment 1

can you post your SP and triggers code?

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: IT Manager



### Comment 2

Hi Rhonda,


First of all you should clearly and at least look at upgrading to version 14.10 xC2, because 11.70 maintenance will stop by March 30th 2020.

On the other hand, I would SET TRACE ON in the Stored procedure and check what the procedure does, jointly with setting sqltrace on on the engine and see what sql statements are executed exactly.

At least start with that. 

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: Everything you want to know about digitally transforming your ERP and live happy




## Related Product
[IBM Informix](https://www.g2.com/products/ibm-informix/reviews)

## Related Category
[Relational Databases](https://www.g2.com/categories/relational-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4