Hexagon Geospatial
MENU

GeoMedia Smart Client

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 40
Registered: ‎04-12-2016

Iterator Trigger

 

Hi,

 

Is there any known issue with Iterator triggers in GMSC v. 2016?

 

I'm trying to use a simple one, with the following code, but it doesn't work!

 

<FormTable name="IDPERITO" idfield="ID" label=" " lov="SQL[SELECT DISTINCT ID, NOME FROM DROTA_RecursosHidricos.dbo.DPM_PedidoPericiaJudicial_LV_Peritos]" defaultvalue="SQL[Select DISTINCT IDPERITO From DROTA_RecursosHidricos.dbo.DPM_PedidoPericiaJudicial_Peritos Where IDPEDIDO = {FORM.ID}]" visible="true" persisted="false" selectionmode="multiple" saveinsession="true">
<FormTableField name="NOME" label="Peritos" datatype="string" />
</FormTable>

 

<WorkflowTrigger name="AssignPeritoTrigger" type="SqlIteratorTrigger" method="afterinsert,afterupdate" >
<Param name="Sql" value="Insert Into DROTA_RecursosHidricos.dbo.DPM_PedidoPericiaJudicial_Peritos (IDPEDIDO, IDPERITO) Values ({FORM.ID}, {FORM.IDPERITO})"/>
</WorkflowTrigger>

 

Any ideas?

 

TIA,

 

Nuno

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.