#1 2012-06-14 14:09:11

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)

Offline

#2 2012-06-15 18:17:08

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,192
Website

Re: TSQLRecordVirtualTableAutoID RowId

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

Thanks for the report!

Offline

#3 2012-06-15 22:07:17

chapa
Member
Registered: 2012-04-30
Posts: 117

Re: TSQLRecordVirtualTableAutoID RowId

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

Offline

Board footer

Powered by FluxBB