- Code: Select all
string cField = JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValueCollection.ReadCustomFieldValue(salesOrder.Manager, "IN_CustomSettingValues", "InventoryID", inventory.InventoryID, "IProduct");
cField is ending up as null.
But if Irun sql profiler and take the following and run it in SSMS it returns a value as True which is what I am expecting it to do
- Code: Select all
exec sp_executesql N'SELECT Contents FROM IN_CustomSettingValues WHERE InventoryID = @ID AND SettingID = (SELECT SettingID FROM IN_CustomSetting WHERE SettingName = @SettingName)',N'@ID char(20),@SettingName varchar(8)',@ID='ECBF488B31CE4E80B867',@SettingName='IProduct'
Any ideas as to what would cause the function call to return null?