UDT Handler FIELDS

Bart De Cattelle

I have a usertable with following columns : DocENtry, LineNum, Itemcode , Color, SIze.

The two last fields color and size must be filled in by the user.

The other columns (DocENtry, LineNum, ItemCode) should be filled in automatically with the udt handler.

The columns DocENtry and LineNum are filled in, but I do not manage to fill in the Itemcode automatically.

I have created Itemcode as param and I am also able to use it im my formtitle, but it is not filled in in my "fields" in udt.

Is this possible and how can this be done?



Is there some more info available about UDT Handler

Anders Olsson

Hi Bart,



It's possible. The key is to specify ItemCode in the filter.



See attached pictures.



Regards,

Anders Olsson

Remo Kottonau

.. mentioned solution above isn't working somehow. We have a Field called U_LNK_ID which should be filled by parameter ItemCode. The WHERE clause in UDT Handler Configuration is as follows:



[CODE]U_LNK_ID = '[%ItemCode]'[/CODE].



The filter works if there is at least one record in our user defined table which matches filter conditions (otherwise we get an error message). But the ItemCode isn't filled in automatically :-/



Customize Version: 3.35.15789

Anders Olsson

Hi Remo,



I added such a configuration, but I must have missed something - it's working as it should. Could you please add screenshots of your configuration (including the fields tab)? Are there any errors in coresuitedebuglog.xml?



Regards,

Anders

Remo Kottonau

The error only occurs if a Field uses ChooseFromList-Type to look up values and if no record in the UDT matches the filter criteria.





[xml] <stacktrace>

<stackframe number="0" line="0" column="0">

<method>UDTUtils.Log</method>

<file />

</stackframe>

<stackframe number="1" line="0" column="0">

<method>UDTForm.Start</method>

<file />

</stackframe>

<stackframe number="2" line="0" column="0">

<method>ThreadHelper.ThreadStart_Context</method>

<file />

</stackframe>

<stackframe number="3" line="0" column="0">

<method>ExecutionContext.Run</method>

<file />

</stackframe>

</stacktrace>

<description>Data Table - invalid column Unique Id [66000-135]

bei SAPbouiCOM.DataTableClass.SetValue(Object Column, Int32 rowIndex, Object Value)

bei SwissAddonFramework.UI.Components.GridSAP.SetValue(String columnUniqueId, Int32 gridRowIndex, String value)

bei SwissAddonFramework.UI.Components.Grid.SetValue(String columnUniqueId, Int32 gridRowIndex, String value)

bei COR_Customize_UDTHandler.View.UDTForm.setDefaultValuesInLastRow()

bei COR_Customize_UDTHandler.View.UDTForm.createGrid()

bei COR_Customize_UDTHandler.View.UDTForm.Start()</description>[/xml]

Anders Olsson

Hi Remo,



I created a UDT Handler with an identical configuration (as far as I can see) but could not reproduce the error.

I would suggest that you contact support so they can have a closer look at this problem.



Regards,

Anders



Support contact details:

http://www.coresystems.ch/?page_id=33&header_id=44&country=en

Remo Kottonau

.. thank you very much Anders.