mORMot Open Source

israel_jbl

Member

Registered: 2019-08-29

Posts: 5

Problem concatenating strings in where clause

I got this error:

FMessage 'Error SQLITE_ERROR (1) [select ID,FirstName,LastName,ZoneName,BirthDate  from userx where FirstName||" "||LastName like "%AAA%"] using 3.30.1 - no such column: ID, extended_errcode=1'

Without concatenate in where clause it works fine.

All my tables are external with PostgreSQL 11.

Using TSQLRestServerDB, the query is executed in server side with ExecuteList method.

TSQLUserX = class(TSQLAuthUser)
  private
    FFirstName: RawUTF8;
    FLastName: RawUTF8;
    FBirthDate: TDateTime;
    FSex: TSQLSex;
    FEMail: RawUTF8;
    ...

Thanks in advance. You do an amazing job.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Problem concatenating strings in where clause

Did you try with RowID?

israel_jbl

Member

Registered: 2019-08-29

Posts: 5

Re: Problem concatenating strings in where clause

It works.

Thanks a lot.