on 04-05-2016 6:38 AM
Hi All
While am trying to run the above SQL in BODS Scirpt am finding a Syntax Error.
Can any help.
ODBC data source(DDTCSQL31.fremont.lamrc.net) error message for operation(SQLExecute): ([Microsoft][SQL Server Native Client 11.0 [SQL Sserver] Incorrect syntax near','.
regards
Karthik
Try to get this correct in your database client, first. Then add a backslash before every single quote when embedding it into a DS sql function call.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please follow the Scripting Guidelines. In some cases you need to provide the Escape Characters.
Also strings including curly braces or square brackets cause a processing error. We can avoid the error by preceding the braces or brackets with a backslash (\).
Source:Data Services Scripting Language
Regards,
Akhilesh Kiran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.