Using SP!dbo. in CS9 for Event type Method Call?

In CS9, if you use the old SP!dbo. option in an Event type Method Call, can you use RVAR to return values? It does not seem to be working for me. I wanted to fire an Event type Form Script which fires another Event which executes a stored procedure, return and value, and use that value in the calling Event to raise an appropriate MsgBox status.

Find more posts tagged with

Syteline Development

Comments

Legacy Contributor

I don't believe so. When you call a SP like that directly, it executes on the SQL layer and the Event system is unaware of the actions it took. Same with SQL-based triggers. The only exception to that is if the SP had logic in it to call back to the event system. But it wouldn't be to the same event/action that you called it from.

Legacy Contributor

Full disclosure: Stored procedures cannot be used outside of on-premise deployments, the most future proof option is to wrap what you need into custom assembly (C#/VB) code.

That said it is worth seeing if you can have the stored procedure as an IDO method with return values, there may be a few standard examples of this which you can reference.

if it is an IDO method call then it should be something which you can verify and smoke test on a form, then embed into an event call, then validate it is still working as expected.

Legacy Contributor

I have many SP!dbo… SP calls that return values correctly into RVARs. These were grandfathered in from a previous version where there was no access to the middle layer/IDO. I asked a high-up, longtime Infor tech employee and he said response time on these are not greatly improved by moving into an IDO - and I believe some of the new versions include a means to create SQL code from CSI - so it is not required to move into a different technology at this time.

Note that you should ensure your RVAR variables are "staying" in the form. If they keep disappearing on you when you reopen the form, you might want to put them on your form and hide them … you'll see many variables like this on standard forms. Also lets you easily see (in edit mode) the value of the variable if/when you are debugging.

Hope this helps.

Wichtige Lösungen in der Wissensdatenbank April 2013.pdf

Rees Howel

Gecko is correct. SP! can be used to return data to RVAR Variables provided they hang around. As I found the other day, if I neglect to create the variable with the Persistent flag set or bind then to a form object (hidden or not), the variables are inclined to be missing next time you open the form.

Copyright © 2025 Infor. All rights reserved.