I have view that is smartobject based, one column region id has a drop down list box it has source of stored procedure based smartobject, problem is the region id does not get populated. Please guide, thanks.
Page 1 / 1
Hi pankaj1
Do you mean that the drop down list is completely empty or one of the fields of the data source is blank?
Please share the stored procedure if possible.
Hi sir, the stored procedure returns values when executed independently.
Eg select distinct country from region.
Drop down list is totally empty. When i press add button for new record then ddlbox populates, but not for existing records. Hope i am clear in explaining ?
Eg select distinct country from region.
Drop down list is totally empty. When i press add button for new record then ddlbox populates, but not for existing records. Hope i am clear in explaining ?
I'm assuming you've found the list control's data source to a SmartObject, which in turn is linked to the stored procedure? If this is the case, you can try executing the SmartObject in a vacuum (SmartObject Service Tester or Management site) to make sure it is returning values. If it does, then we can focus on form rules. If it does not, then there is something amiss with the Smartobject. If you are populating this list differently than how I've described above, please elaborate.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.