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

ok last tips:
-select a custom datasource
-select the source type
-enter the ip
-enter the username and the password
-use this statement substituting [AppianHSE] with the name of your database and [HSE] with [PROJECT], remember to use [dbo]
select TOP 12 ID from (select ID from [AppianHSE].[dbo].[HSE] WHERE [AppianHSE].[dbo].[HSE].ID=ac!oldID)_result
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 marcoc200 over 10 years ago

ok last tips:
-select a custom datasource
-select the source type
-enter the ip
-enter the username and the password
-use this statement substituting [AppianHSE] with the name of your database and [HSE] with [PROJECT], remember to use [dbo]
select TOP 12 ID from (select ID from [AppianHSE].[dbo].[HSE] WHERE [AppianHSE].[dbo].[HSE].ID=ac!oldID)_result
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data