Active Query Builder support area

String concatination doesn't work for SQLite

Avatar
  • updated
  • Completed

I'm not able to concat strings because of parse error , do you have a way around this ?

Simple Example here:

Select 'hello' || 'You'

should result in helloYou with no error

this works just fine in any sql command

Avatar
Andrey Zavyalov, PM

Hello,

Thank you for your interest in Active Query Builder.

What is your database server? What syntax provider have you used?

Avatar
Shlomi Hoota

Thanks for the quick replay,

using sqlite ,SQLiteSyntaxProvider

Avatar
Andrey Zavyalov, PM

Thank you for your feedback. This bug will be fixed in the next build.

Avatar
Andrey Zavyalov, PM

Hello, Shlomi.

The fixed build is available for downloading now.