NetSuite ODBC Driver and Custom Fields
I am not having success in accessing the custom fields for table InventoryItem.
the fields are defined correctly, and do appear [in another competing product] in the standard select of
select * from InventoryItem
as a pair of fields for each defined custom field: Color, Color_InternalId
In DevArt, the custom fields do not appear at all when selecting all fields, and if specifying a specific field the error returns
select type from InventoryItem
[DevArt][ODBC][NetSuite]Unknown column 'type'
I currently have two types of Custom Fields ( customFieldType in table CustomFields )
Neither type of Custom fields are returned
In the TUniConnection component the Options for 'CustomFields' and 'CustomTables' are both set to 'True'.
In NetSuite itself, these fields appear under the Item 'Attributes' section