Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
9 subscribers
Views
2621 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Could anyone tell why the sql can't execute smoothly? for e.g, select
simony
over 12 years ago
Could anyone tell why the sql can't execute smoothly?
for e.g, select concat(a,b) as test from tbtest? a, b are the columns in table tbtest.
This sql can execute smoothly before the upgrade to 6.7. There always an error message : There was a problem during the validation of the SQL statement with the database
The database returned ARV's that may not be supported. Message: test
Thank you so much!...
OriginalPostID-43209
OriginalPostID-43209
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 12 years ago
What database are you using? Also, instead of specifying AS to your alias statement, can you try without it?
for e.g. concat(a,b) TEST, ...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 12 years ago
What database are you using? Also, instead of specifying AS to your alias statement, can you try without it?
for e.g. concat(a,b) TEST, ...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data