Good day everyone..
I am using the defult Derby DB. I managed to create the query for the object and add the "Row_Number () Over()" on the query. The query show very good
==================
Select
ROW_NUMBER() Over () As Row..
.....
FROM ....
==================
Results
Row
-----
1
2
3
==================
Now I trying to connect back to the AwareIM Derby (Same DB) but it show the error.
"Aware IM Server encountered the following error. Syntax error: Encountered "(" at line 3, column 26."
No matter how I do, the errror message always the same.
Is AwareIM able support the function of "ROW_NUMBER() Over()"?
Thanks.