mORMot Open Source

bigheart

Member

Registered: 2014-08-01

Posts: 53

How to set subquery for sqlite in mORMot

Dear sir,

I'd like to query from sqlite as below:

  SELECT * FROM tracks WHERE bytes = (SELECT max(bytes) FROM tracks);

How to above query using TSQLRecord.CreateAndFillPrepare.

Thanks in advance.

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: How to set subquery for sqlite in mORMot

Did you tried using 'bytes = (SELECT max(bytes) FROM tracks)'?

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

bigheart

Member

Registered: 2014-08-01

Posts: 53

Re: How to set subquery for sqlite in mORMot

It works.

Thank you.