Ask a questionAsk a question
 

AnswerBusiness Data Column Problem.

  • Friday, June 19, 2009 2:55 PMHamed_1983 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi
    i add a business data column to my sharepoint list, it works sucessfully, but when i want to add a new item to list, when i browse to specific lob data via popUp window, select my lob item and click ok, i got this message :

    No exact match was found

    while i found it and select it. where is my problem and how to solve it ?

    Note : i select columnX in bdc column setting, but when i select my lob item from popUp window, it display columnY (it's PK) in list, i think something is wrong but i don't know which one.

    thanks in advance

    this is my Signature

Answers

  • Monday, June 22, 2009 10:32 AMNick SwanMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    This means there will be a problem with your specific finder method as it is returning more than a single row.

    Remember the specific finder method should accept identifier parameters so it returns just a single record of data.

    To help diagnose this you can use SQL Query Analyzer to see what queries are being executed (pressuming you are using SQL Server)

    HTH
    Nick
    http://www.bdcmetaman.com

All Replies

  • Monday, June 22, 2009 10:32 AMNick SwanMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    This means there will be a problem with your specific finder method as it is returning more than a single row.

    Remember the specific finder method should accept identifier parameters so it returns just a single record of data.

    To help diagnose this you can use SQL Query Analyzer to see what queries are being executed (pressuming you are using SQL Server)

    HTH
    Nick
    http://www.bdcmetaman.com