mORMot Open Source

A rest orm server:

   server:  TserRestServerDB

   client:TRESTHttpClient

   model:TOrmBiolife = class(TOrm)

 
client:
    Rec := TOrmBiolife.Create;
  try
    Rec.Species_No := strtoint(NameEdit.Text);
    Rec.Category:='test';
    rec.Common_Name:='testname';
    id:= Database.Add(rec,true,true,false);   //failed to add，why ?   

server log is :
20240815 10053656  -    00.000.681
20240815 10054513  +    mormot.rest.sqlite3.TSqlRestServerDB(016560a0).URI POST lqf/Biolife in=120 B
20240815 10054513 EXC           ESqlite3Exception {Message:"Error SQLITE_CONSTRAINT (19) [Step] using 3.44.2 - NOT NULL constraint failed: BIOLIFE.ID, extended_errcode=1299",ErrorCode:19,SQLite3ErrorCode:"secCONSTRAINT"} [HttpSrv 8080lqf THttpApiSrv] at 010063f39d

Isnt  the Table id controlled by RestServer? I am confused,  can anyone help me ? thank you

THttpServerRequest
THttpServerRequestAbstract
TSQLRestServerURIContext

I'm a little confused

windows10 +fpc

execute the SQL   on the client with zeos :  select * from 测试      (测试 is  tablename and it does exist)

while the server console  give these:

20240720 01375433  # auth       mORMot.TSQLRestRoutingREST(07aa2180) User/1805053736 192.168.3.178
20240720 01375434  # call       mORMot.TSQLRestServerFullMemory(01581140) IRemoteSQL.Execute["select * from  测试",true,false]
20240720 01375434  ! DB    SynDBZeos.TSQLDBZEOSStatement(015f5e70) Prepare 120us select * from  测试
20240720 01375434  ! EXC   EZSQLException ("SQL Error: Table 'testdb.娴嬭瘯' doesn't exist \r\nCode: 1146 SQL: select * from  娴嬭瘯") [] at 0100290747

        ORM core Exception show me a wrong table name,  how to fix it? sir,thanks!

win10+lazarus3.4
 
installed zeos from online package manager

uses SynDBZeos

compiling...and it told  this:

    SynDBZeos.pas(190,3) Error: Cannot find ZURL used by SynDBZeos.

but  in fact,I can jump to ZURL，I dont know why it happen,any idea?thanks!

I've looked all over the internet, but no one has the same problem as me！