mORMot Open Source

chapa

Member

Registered: 2012-04-30

Posts: 117

TSQLRecordVirtualTableAutoID RowId

In function:

function TSQLRestServer.URI()
  ...
      if Context.Method<>mLOCK then begin // LOCK not available here
        SQLSelect := 'ID'; // if no select is specified (i.e. ModelRoot/TableName)

We assume that row id column is named 'ID', which is wrong in case when using VirtualTable.
Calling ModelRoot/TableName returns BadRequest, due to wrong SQL query involving column 'ID' instead of 'rowid'.

Last edited by chapa (2012-06-14 14:20:32)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: TSQLRecordVirtualTableAutoID RowId

It should be fixed now by http://synopse.info/fossil/info/aa10d080dd

Thanks for the report!

chapa

Member

Registered: 2012-04-30

Posts: 117

Re: TSQLRecordVirtualTableAutoID RowId

Thank you very much ab,
Will give the new build a try tomorrow.