mORMot Open Source

cregonat

Member

Registered: 2020-04-27

Posts: 7

Commit from 15-01-21 [c1a508e] and 'nocache'

Hello,

I have a backend for an Android app that worked without problems when running this code:

    FOrden := TOrdenProduccion.CreateAndFillPrepare(DBController.CMain, 'NroOrden=? AND EsMatriz=0 AND IdMaquina=0 '
      + '/*nocache*/', [lIdOrdenStr])

this doesn't work anymore since the commit of 15-01-21 (fixed TSynTableStatement parsing), and it seems that the /*nocache*/ isn't parsed in the same way as before.

should I avoid using nocache there?

Thanks

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Commit from 15-01-21 [c1a508e] and 'nocache'

You are right.
This was a regression: the "adapt SQL" feature was not ignoring the comments.

Please check https://synopse.info/fossil/info/56a6ad9508

cregonat

Member

Registered: 2020-04-27

Posts: 7

Re: Commit from 15-01-21 [c1a508e] and 'nocache'

Great,

it now works,

Thanks!