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.
LookUp('[dbo].[VIEW_KDL_WITH_SW_DOCID]',DrawingNumber=CurrentPartNumber And Text(RevisionNumber)=(CurrentRevision))
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.
Please check if the column of your base table is changed .
Please check if the base table has been deleted .
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
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks