Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SharePoint Products and Technologies >> SharePoint - Business Data Catalog

RdbCommandText without parameters => actions don't allow parameter?

If my RdbCommandText contains no parameter, it isn't possible to have an action with a parameter?

I tried just to define a simple SELECT statement (without any parameters) and defining the Actions in the XML file or in the SharedServices ("Add Action"). Every time I defined an Action with a parameter the hover dropdown link displayed "No action". An action without any parameter works finely.

Where do I have to specify the parameters for the Actions?

I tried to add a parameter in the <Method> section but this failed with this error:

Exception handed to HandleRuntimeException.HandleException System.ArgumentException: Could not find exactly 1 Member with name 'Title' Parameter name: fieldName at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractInstance.get_Item(String fieldName) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.GetFormatted(String fieldName) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.EntityAsDataRow(DataTable tableToAddRowTo, Boolean formattedFields) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.EntityAsFormattedDataRow(DataTable tableToAddRowTo) at Microsoft.Office.Server.ApplicationRegistry.Runtime.EntityDataTableAdapter.Populate(UInt32 offsetFromStart, Int32 rowCount) at ...
...Microsoft.Office.Server.ApplicationRegistry.Runtime.EntityDataTableAdapter.Initialize(IEntityInstanceEnumerator dataSource, UInt32 offsetFromStart, Int32 rowCount) at Microsoft.Office.Server.ApplicationRegistry.Runtime.EntityDataTableAdapter..ctor(IEntityInstanceEnumerator dataSource, Boolean createSerializedIdColumn) at Microsoft.SharePoint.Portal.WebControls.BdcDataSourceView.GetDataView(IEntityInstanceEnumerator entityInstanceDataReader) at Microsoft.SharePoint.Portal.WebControls.BdcDataSourceView.GetList(Entity entity) at Microsoft.SharePoint.Portal.WebControls.BdcDataSourceView.GetEntityInstances(Entity entity) at Microsoft.SharePoint.Portal.WebControls.BdcDataSourceView.ExecuteSelect(DataSourceSelectArguments args) at System.Web.UI.DataSourceView.Select(DataSo...
...urceSelectArguments arguments, DataSourceViewSelectCallback callback) at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal() at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator() at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator(IDataSource datasource, Boolean originalData) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXPathNavigator(String viewPath) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform()
System.ArgumentException: Could not find exactly 1 Member with name 'Title' Parameter name: fieldName at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractInstance.get_Item(String fieldName) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.GetFormatted(String fieldName) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.EntityAsDataRow(DataTable tableToAddRowTo, Boolean formattedFields) at Microsoft.Office.Server.ApplicationRegistry.Runtime.AbstractEntityInstance.EntityAsFormattedDataRow(DataTable tableToAddRowTo) at Microsoft.Office.Server.ApplicationRegistry.Runtime.EntityDataTableAdapter.Populate(UInt32 offsetFromStart, Int32 rowCount) at Microsoft.Office.Server.ApplicationRegistry.Runtime.Entity...
...DataTableAdapter.Initialize(IEntityInstanceEnumerator dataSource, UInt32 offsetFromStart, Int32 rowCount) at Microsoft.Office.Server.ApplicationRegistry.Runtime.EntityDataTableAdapter..ctor(IEntityInstanceEnumerator dat

[3709 byte] By [Erulu] at [2008-2-23]
«« Customized IfElse activity in re-hosted Workflow Designer from kushals
»» Elapsed time in Delay Activity
# 1

1. It is possible to have action without parameter. But one reason to use parameter is to pass it to the other web page for action. For example, if you have an edit action, you want to pass an ID so that the page knows what to load for editing. But if you are adding, you may not need to pass any parameters. If you make a mistake in your action definition, your action won't show up.

2, You define actions in your AppDefFile or use SharedServices. It is easier to start with SharedServices as you can make fewer mistakes. Goto: SharedServices->View Entities. Select an Entity and select Add Action.

FrankChiang at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
# 2
Frank Chiang wrote:

It is easier to start with SharedServices as you can make fewer mistakes. Goto: SharedServices->View Entities. Select an Entity and select Add Action.

I did exactly what you said but it doesn't work. In my case it was not possible to add an Action with a parameter when the parameter was not defined in the application defintion file. Perhaps I did something wrong but adding a redundant parameter in the parameters section and in the select statement makes it work! I'll figure this out in a simple example, perhaps there was something wrong in my ADF.

Erulu at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
# 3
You have solved the problem without really knowing why! The way action parameter can work is that there has to be a 'specificfinder' method, because that is how BDC can find out the values of all the paramters for a specific record so that action can pass it(or them) to another url. If your select statement has no parameter, then specificfinder won't work and therefore action parameters are not available. By specifying a parameter in your select statement, specificfinder works and therefore action parameters works. But you have to be sure that the parameter that you specify is the primary key or a unique key.
FrankChiang at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
# 4

Frank Chiang wrote:
The way action parameter can work is that there has to be a 'specificfinder' method, because that is how BDC can find out the values of all the paramters for a specific record so that action can pass it(or them) to another url. If your select statement has no parameter, then specificfinder won't work and therefore action parameters are not available. By specifying a parameter in your select statement, specificfinder works and therefore action parameters works. But you have to be sure that the parameter that you specify is the primary key or a unique key.

Ah! Thanks a lot. Either I've overseen it in the docs or this is not so detailed mentioned. But nevertheless things are going to work (slowly ) and my BDC knowledge increases...

Erulu at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
SharePoint Products and Technologies
SharePoint - Business Data Catalog

SharePoint Products and Technologies Hot Topic

SharePoint Products and Technologies New Topic

SharePoint Products and Technologies

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified