NetSuite ODBC Driver and Custom Fields
Posted: Wed 03 Apr 2019 04:20
Using DevArt ODBC for NetSuite, and UniDAC with the NetSuiteProvider
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 )
itemCustomField
itemNumberCustomField
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
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 )
itemCustomField
itemNumberCustomField
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