Announcements
190
When upgrading to a new version of GP...If a stored proc in the business object is updated with a new parameter (thus also updating the pre/post stored proc parameters)...will our custom code in the pre/post stored proc be carried over?
*This post is locked for comments
[quote user="ausomecasey"]will our custom code in the pre/post stored proc be carried over?[/quote]
Hi Casey,
All pre and post stored procedures are dropped and re-created automatically during the upgrade process - this means you will lose all the custom logic inside them.
Copy and paste the logic only (leave the parameters alone) from your old version to the logic section of the new pre/post proc (again - leave the parameters alone).
Thanks,
Why don't you take any econnect Stored procedures as an example? Make custom changes in the triggers and Do a GP upgrade. After the upgrade check the trigger.
@Soma If we restore the original trigger after GP upgrade, it will undo the changes done by GP upgrade. In that case You will have the old parameter in the stored procedure which is incorrect, also GP application code and stored procedure wouldn't match with parameters. Thoughts?
Hi Soma, Are you saying that pre/post stored procedure will work after upgrade in case of any change in parameter?
Hi Casey,
The answer is No. It will be gone, unless you have a backup or save it in a different name. After upgrade, you have to manually copy your custom code to the stored procedures.
Hope it helps.
Thanks,
Shan
The stored procedure triggers are fire based on name of the stored procedures used inside your triggers. It wont consider any parameter or other changes inside the stored procedure. So, I think your triggers will be work without any problems.
Hope this helps!!!
Hi, as far as I know every time when there is an upgrade these store procs are created unless you have renamed them to a different name.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
