{{tag>category:"OpenInsight 64-bit" author:"Barry Stevens" author:"Andrew McAuley"}} [[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]] ==== OI10 Promoted Events (OpenInsight 64-bit) ==== === At 31 OCT 2023 06:49:33PM Barry Stevens wrote: === Is there any further information yet on the promoted events IDE functions in OI10. I am referencing from the 'Building OI10' ---- === At 01 NOV 2023 04:52AM Andrew McAuley wrote: === Try File/New Entity and choose promoted events. The dialog is quite self-explanatory in the absence of docs :). I now use them a lot more and have a static on the form to remind me a promoted event is in use, which can be removed on a promoted create event :). [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] ---- === At 01 NOV 2023 03:13PM Barry Stevens wrote: === Try File/New Entity and choose promoted events. The dialog is quite self-explanatory in the absence of docs :). I now use them a lot more and have a static on the form to remind me a promoted event is in use, which can be removed on a promoted create event :). [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] I already have promoted events, so, I assume I need to use SYNCH_REPOS_PROMOTED_EVENTS to ;register' them. What parameter values should be used in the first instance. ---- === At 02 NOV 2023 05:48AM Andrew McAuley wrote: === SYNCH_REPOS_PROMOTED_EVENTS is self contained, in that if you run it with no parameters it will just seek out all promoted events and if SYSREPOS entries don't exist it will create them. Opening the stored procedure executable in the IDE reveals that it takes 3 parameters - bUpdate EvId bExe If bUpdate is set to TRUE$, if the SYSREPOS row already exists it will be UPDATED with a new description. If the promoted event id is passed in EvID then just the pointer for the SYSREPOSEVENTS event will be created/updated. If bExe is TRUE, the SYSREPOSEVENTEXES row will be created/updated. However this should have happened during the conversion, so in case there's anything funny going on, make sure you back up first. [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] ---- === At 02 NOV 2023 07:50AM Andrew McAuley wrote: === If the promoted event id is passed in EvID then just the pointer for the SYSREPOSEVENTS event will be created/updated. If bExe is TRUE, [i]then just the pointer for[/i] the SYSREPOSEVENTEXES row will be created/updated. [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] ---- === At 02 NOV 2023 03:28PM Barry Stevens wrote: === If the promoted event id is passed in EvID then just the pointer for the SYSREPOSEVENTS event will be created/updated. If bExe is TRUE, [i]then just the pointer for[/i] the SYSREPOSEVENTEXES row will be created/updated. [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] Great, thanks ---- === At 02 NOV 2023 03:30PM Barry Stevens wrote: === SYNCH_REPOS_PROMOTED_EVENTS is self contained, in that if you run it with no parameters it will just seek out all promoted events and if SYSREPOS entries don't exist it will create them. Opening the stored procedure executable in the IDE reveals that it takes 3 parameters - bUpdate EvId bExe If bUpdate is set to TRUE$, if the SYSREPOS row already exists it will be UPDATED with a new description. If the promoted event id is passed in EvID then just the pointer for the SYSREPOSEVENTS event will be created/updated. If bExe is TRUE, the SYSREPOSEVENTEXES row will be created/updated. However this should have happened during the conversion, so in case there's anything funny going on, make sure you back up first. [url=https://www.sprezzatura.com]The Sprezzatura Group[/url] [url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url] [i]World leaders in all things RevSoft[/i] [img]https://www.sprezzatura.com/zz.gif[/img] Yep, it did. [[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=95EF64F984E42F488A9D759B987A04E1|View this thread on the Works forum...]]