Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray0801
Creator
Creator

Multi Part Identifier Could Not Be Bound in Mssql Server

I am storing a date in a context variable date

context.xxxDate.

When I try to write it inside a query.

Select * from Source_Table Where Date_Field > context.xxxDate and When I run the job.

I am getting

Multi Part Identifier Could Not Be Bound error. Is there anything wrong with the syntax.

Exception in component tDBInput_1 (xxxxxxxxx_Job)

java.sql.SQLException: The multi-part identifier "context.xxxDate" could not be bound.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello,

Please make sure there is no any missed single quote around your variable.

Best regards

Sabrina

View solution in original post

3 Replies
Anonymous
Not applicable

Hello,

Please make sure there is no any missed single quote around your variable.

Best regards

Sabrina

Ray0801
Creator
Creator
Author

@Xiaodi Shi​ That was the case,I forgot single quotes around my variable.

Anonymous
Not applicable

Hello,

Great it works. Thanks for letting us know it.

Best regards

Sabrina