cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Binding Error in Form DataSource Item

I am doing a rather typical form situation.  The form source is one SQL View.  The following statement yeilds a Binding Error.  I have no idea what it is, but the statement is correct.  I have used very similar statements for other forms.  Please advise.

 2019-01-13 18_48_29-NVIDIA GeForce Overlay.png

LookUp('[dbo].[VIEW_KDL_WITH_SW_DOCID]',DrawingNumber=CurrentPartNumber And Text(RevisionNumber)=(CurrentRevision))

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Binding Error in Form DataSource Item

Hi @martinav ,

Can you show me your structure of your SQL View ?

Can you show me your base tables of your SQL View ?

 

The error message should be caused by your data source.

 

I made a test. There’s no issue on my side.

8.PNG

9.PNG

 

Please check if the column of your base table is changed .

Please check if the base table has been deleted .

 

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Binding Error in Form DataSource Item

@v-sheyu-msft,

 

Sure.  This is an old table I have been using for quite a while.  The statement is a little busy because of crossing to a different instance.  But, the table resolves fine.

 

SELECT        TOP (100) PERCENT [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNumber, [Kelso-Prod].dbo.tbl_Drawings.Title, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNotes, 
                         [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionDate, [Kelso-Prod].dbo.tbl_Drawings.Project, [Kelso-Prod].dbo.tbl_Drawings.IsActive, [Kelso-Prod].dbo.tbl_DrawingRevisions.DrawingFile, 
                         [Kelso-Prod].dbo.tbl_Drawings.Component, [Kelso-Prod].dbo.tbl_Drawings.DateDrawn, dbo.SWPDM_DocumentIDFromPartNo.DocumentID
FROM            [Kelso-Prod].dbo.tbl_Drawings INNER JOIN
                         [Kelso-Prod].dbo.tbl_DrawingRevisions ON [Kelso-Prod].dbo.tbl_Drawings.idDrawing = [Kelso-Prod].dbo.tbl_DrawingRevisions.idDrawing INNER JOIN
                         dbo.SWPDM_DocumentIDFromPartNo ON [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber = dbo.SWPDM_DocumentIDFromPartNo.ValueText COLLATE SQL_Latin1_General_CP1_CI_AS
ORDER BY [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNumber DESC

2019-01-14 08_30_52-KT-ES-01.Martin-Test_OLD - dbo.VIEW_KDL_WITH_SW_DOCID_ - Microsoft SQL Server Ma.png2019-01-14 08_31_11-KT-ES-01.Martin-Test_OLD - dbo.VIEW_KDL_WITH_SW_DOCID_ - Microsoft SQL Server Ma.png

 

Administrator
Administrator

Re: Binding Error in Form DataSource Item

adding in @GregLi to review and assist. 

 

@TopShelf-MSFT

Super User
Super User

Re: Binding Error in Form DataSource Item

@TopShelf-MSFT,

 

Thats fantastic.  Thanks for that!