mORMot Open Source

Ajax implementations I've seen, do not know is developed in Delphi clients how to achieve pagination effect? For example, I want to get the data page of a table by calling TSQLRest.MultiFieldValues method returns only All data and interface parameters can be no return to specify a page of data.

I did not customize URIPagingParameters parameters, or is it the default values used by In the code directly call TSQLRestClientURI.URI method can achieve the effect of acquired paged data, Url parameter TSQLRestClientURI.URI is processed by hand, like this "/ Cs006 / c2105recdata /? Select = * & startindex = 0 & results = 30 & sort = RecTime & dir = desc".

In this way is not a problem, or that it is not the correct usage?
In addition, TSQLRest.MultiFieldValues can implement paging control it?

thanks

Thank you very much, I should go to learn more.

Today failed to run TestSQL3, MainDemo also not working, TestSQL3 exception information is as follows:
--------------------------------------------------------------
2. mORMot

2.1. File based:

! Exception ESQLite3Exception raised with messsage:
!  unrecognized token: "'a鐚?, 1791, 1872);"
--------------------------------------------------------------

Tracking source code, should feel no recognizes MS SQL uniqueidentifier type TSQLDBConnectionProperties.ColumnTypeNativeToDB method.

In the case of manually creating tables, found the following exceptions:
20140707 10311161 SQL   TOleDBStatement(02B687E0) insert into dbo.CollectPointRecord (ID,CollectPointID,CollectPointName) VALUES (?OOR?,?OOR?,?OOR?)
20140707 10311161 EXC   ESQLDBException ("Invalid TOleDBStatement.Bind(2,TSQLDBFieldType(0),24A7499C-358E-43AC-B740-F37A5A631BF5)") at 001A99DA SynDB.TSQLDBStatement.Bind (5079) 
stack trace API
    001238A8 SynCommons.SynRtlUnwind (39860)
    000090F0 System.@HandleAnyException (18659)
    001A99DA SynDB.TSQLDBStatement.Bind (5079)
    001B34E8 mORMotDB.TSQLRestStorageExternal.ExecuteFromJSON (1556)
    001B15EF mORMotDB.TSQLRestStorageExternal.EngineAdd (1057)
    0017E501 mORMot.TSQLRestServer.EngineAdd (26741)
    00171407 mORMot.TSQLRest.Add (22991)

Correlation table definition：
CREATE TABLE [dbo].[CollectPointRecord](
    [ID] [int] NOT NULL,
    [CollectPointID] [uniqueidentifier] NULL,
    [CollectPointName] [nvarchar](30) NULL
) ON [PRIMARY]

Am I overlooking what is content?

In the case of SQL Server, can be stored as a real GUID type?

Great job, thank you very much.

Started trying to develop a small project with mormot, but the same problems encountered GUID attribute, very much hope that this issue can be resolved.

In Client-Server mode,I also encountered the same problem, the server restarts, or after the client and no movement for a long time, operation again the client will get an error. How to reconnect to the server, in addition to restarting the client?

I write this:
  with TSynLog.Family do
  begin
    Level := LOG_VERBOSE;
    OnArchive := EventArchiveSynLZ;
    ArchiveAfterDays := 1; // archive after one day
  end;
  TSynLog.Add.Log(sllInfo, '准备开始下载文件 ...');

My version of IDE is Delphi7(build 4.453)

Indeed, this is the case.

Download the latest version 1.18, the problem is still not resolved for help.