mORMot Open Source

corchi72

Member

Registered: 2010-12-10

Posts: 232

Error: unrecognized token: ":"

Deleting a user performing the example "Synops-sqlite-demo" occurs the error: unrecognized token: ""

I added a button where I run the cancellation of the user with the following code:

procedure TForm1.btnDeleteUserClick(Sender: TObject);
begin
   Database.Delete(TSQLUser,integer(lbUsers.Items.Objects[lbUsers.ItemIndex]));
end;

debuging  I saw that goes wrong when running the following code:
function TSQLRestServerDB.EngineExecuteAll(const aSQL: RawUTF8): boolean;
begin
  try
    DB.ExecuteAll(aSQL); // Execute all statements (don't use fStatementCache[])
    result := true;
  except
    on E: ESQLException do begin
      LogToTextFile('TSQLRestServerDB.EngineExecuteAll Error: '+RawUTF8(E.Message)+#13#10+aSQL);
      result := false;
    end;
  end;
end;

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Error: unrecognized token: ":"

I found the issue.

Corrected in source code repository:
http://synopse.info/fossil/info/8affd6d98d

Thanks for the report

corchi72

Member

Registered: 2010-12-10

Posts: 232

Re: Error: unrecognized token: ":"

ok Thanks