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 it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020