Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I do a tbdinput with this query:
select AA_ID
,DIAGNOSISCLASSCODE
,'GROUP'
,ALLOWEDFUNCIONALCLASS
from XXX
And I have linked this to a tdboutput,
I get this error: BatchUpdateException: Incorrect syntax near 'GROUP'.
I have tried with "GROUP" -> BatchUpdateException: Incorrect syntax near the keyword 'GROUP'.
Is there a way to do this ?
N.B.: I use a dynamic schema.
Thank you
Hello,
Is this an actual column in your DB?
For code generation, the "reserved" keyword is used for that process; and should not be used as a row column name for the schema. This doesn't apply to the "db column", which can be kept with the name at this time.
Best regards
Sabrina
Hi Sabrina,
Thank you for your help.
At the source there is a column named "GROUP" and I can change this, I'm not the owner.
I get this error when I want to insert this in mssql in a table already created.
Hi
Maybe this link is helpful, change the query to be as below:
"select AA_ID
,DIAGNOSISCLASSCODE
,\"GROUP\"
,ALLOWEDFUNCIONALCLASS
from XXX"
or
"select AA_ID
,DIAGNOSISCLASSCODE
,\\[GROUP\\"
,ALLOWEDFUNCIONALCLASS
from XXX"