Hi, Facing issue with DB query node while using simple sub-query. sel

riteshp over 10 years ago

Hi, Facing issue with DB query node while using simple sub-query.

select TOP 12 ID from (select ID from PROJECT WHERE ID=ac!prjId )_result

While validation showing error:

"Errors
There was a problem during the validation of the SQL statement with the database

The SQL Query is invalid, com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword \\'WHERE\\'."

If i remove inner "WHERE ID=ac!prjId" condition it works fine. Appian 7.6 + MSSQL Server2008 + Jboss 6.2

Thanks, Ritesh
...

Discussion posts and replies are publicly visible

Parents

0 marcoc200 over 10 years ago

try with this:
select TOP 12 ID from (select ID from HSE WHERE [AppianHSE].[dbo].[HSE].ID=ac!oldID)_result substituting [AppianHSE].[dbo].[HSE].ID with [PROJECT].ID
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 marcoc200 over 10 years ago

try with this:
select TOP 12 ID from (select ID from HSE WHERE [AppianHSE].[dbo].[HSE].ID=ac!oldID)_result substituting [AppianHSE].[dbo].[HSE].ID with [PROJECT].ID
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data