I’m trying to pass in a SQL statement from a DataGenerator to a DBInputTable component via the Query URL (port:$0.field1:discrete). The problem is that the DBInputTable seems to not be able to process a single quote in my query (SQL snippet below).
I just tested a similar usage with no issues. In order to resolve your issue please provide me with the following.
1. Version of your Designer.
2. Version of your MS-SQL database.
3. Your graph file without any sensitive information.
4. Your console output when the error occurs. Just copy-paste it, please.