Hexagon Geospatial

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 
Posts: 40
Registered: ‎04-12-2016

Iterator Trigger




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" />


<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})"/>


Any ideas?





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