Hi!
I am making a form with autocompleter.
In "Fields to retrieve" box I need to retrieve a pair of id and string with CONCAT of 2 fields from the table record.
When I write the CONCAT function for my needs (please take a look on screenshot) - the search field stops working. I tried functions like COUNT() and UCASE() - they works as expected.
Somehow even CONCAT works with one field, I think there is bug with space character or some thing like that.
Please, help to solve
I am making a form with autocompleter.
In "Fields to retrieve" box I need to retrieve a pair of id and string with CONCAT of 2 fields from the table record.
When I write the CONCAT function for my needs (please take a look on screenshot) - the search field stops working. I tried functions like COUNT() and UCASE() - they works as expected.
Somehow even CONCAT works with one field, I think there is bug with space character or some thing like that.
Please, help to solve
