Skip to Content
0
Former Member
May 12, 2008 at 03:50 PM

User Defined Fields & Tables Problem

71 Views

After the upgrade to B1 2007 and converting our database to 2005 compatibility as per the upgrade directions, we’re having some weird issues with our user defined fields and tables.

• Our user defined fields that used to be alpha-numeric when set up in B1 are now in the database as nvarchar(MAX), even after updating the fields in the Manage User Defined Fields screen. B1 is obviously not setting the right field information as per its interface.

• We’re can no longer add records to user defined tables through the B1 interface, though we can add them fine through SQL Server or an ODBC interface. The error we are getting is

[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the nvarchar value '-3 @PASSWORDS' to data type int. (CINF)

. I don’t understand where this problem is coming from because there isn’t even a data field that is an integer, so I don’t know what it’s trying to convert.