I figured it out.
Ultimately, the checkboxes on UD04_UD where set as nullable in the SQL schema. This doesn’t work! So I had to run an alter command on the table to set them to non-nullable.
Appears to be a bug with the E10 conversion of some sort.
Regards,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 30, 2015 5:05 PM
To: Vantage
Subject: Re: [Vantage] FW: Problem with FKV on a UD table with extended properties
Is your error in a converted customization? And is the error in code or the FKV itself? If its in the FKV you may be better off removing it and re-adding the FKV
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>
Quis custodiet ipsos custodes?
Ultimately, the checkboxes on UD04_UD where set as nullable in the SQL schema. This doesn’t work! So I had to run an alter command on the table to set them to non-nullable.
Appears to be a bug with the E10 conversion of some sort.
Regards,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 30, 2015 5:05 PM
To: Vantage
Subject: Re: [Vantage] FW: Problem with FKV on a UD table with extended properties
Is your error in a converted customization? And is the error in code or the FKV itself? If its in the FKV you may be better off removing it and re-adding the FKV
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>
Quis custodiet ipsos custodes?
On Thu, Apr 30, 2015 at 6:37 PM, 'Tom J. Christie' tchristie@...<mailto:tchristie@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:
We are working on moving from E9 to E10 and I have ran into a crazy problem. I have a FKW from the OrderRel table to UD04. UD04 has extended fields (I needed 5 more checkboxes). When I use this setup, I get an error on the command myUD04Adapter.InvokeSearch(sOpts). It states “DataSet does not support System.Nullable<>.â€
This is an odd one. Any thoughts or idea?
Application Error
Exception caught in: System.Data
Error Detail
============
Message: DataSet does not support System.Nullable<>.
Program: System.Data.dll
Method: .ctor
Client Stack Trace
==================
at System.Data.DataColumn..ctor(String columnName, Type dataType, String expr, MappingType type)
at Ice.ExtendedData.ExtendedDataManager.AddExtendedDataColumns(IIceExtendedTable iceExtendedTable, DataTable destinationTable)
at Ice.DatasetAdapter.CopyTSTableToDataTable[TIceRow,TDataTable](IceTable`1 sourceTSTable, TDataTable destinationTable)
at Ice.Proxy.BO.UD04Impl.GetRows(String whereClauseUD04, String whereClauseUD04Attch, Int32 pageSize, Int32 absolutePage, Boolean& morePages)
at Ice.Adapters.UD04Adapter.OnGetRows(SearchOptions opts, Boolean& MorePages, String[] whereClauses)
at Ice.Lib.Framework.EpiBaseAdapter.GetRows(SearchOptions opts, Boolean& MorePages)
Regards,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130<tel:520.881.2130> ext 2176
________________________________
[Non-text portions of this message have been removed]
