#1 2010-10-23 07:46:55

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,655
Website

SQLite3 Framework updated to 1.10 - including engine 3.7.3

The Synopse SQLite3 Database Framework was just released under version 1.10:
- internal SQLite3 database engine is updated to version 3.7.3;
- code modifications to compile with Delphi 6 compiler;
- enhancements in TSQLRestServerStatic, for easier stand-alone work of this in-memory database engine;
- new SQLite3Edit unit, for automated creation of a UI window, ready to edit any TSQLRecord, with no RAD necessary (all components are created from RTTI): think this is an ORM for User Interface

This version compiles from Delphi 6 up to Delphi XE.
The full source code from the framework is available to download from http://synopse.info/files/SynopseSQLite3.zip licensed under a MPL/GPL/LGPL tri-license (see http://synopse.info/forum/viewtopic.php?id=27).

Changes in unit SynZipFiles
  - code modifications to compile with Delphi 6 compiler

Changes in unit SynPdf
  - new TPdfImage.CreateJpegDirect method and PixelWidth/PixelHeight properties

Changes in unit SynGdiPlus
  - code modifications to compile with Delphi 6 compiler

Changes in unit SynCrypto
   - code modifications to compile with Delphi 6 compiler (Delphi 5 failed due to some obscure compiler bugs in SynCrypto.pas)

Changes in unit SynCommons
  - new StringReplaceChars function
  - code modifications to compile with Delphi 6 compiler

Changes in unit SynZip
  - both obj files (i.e. deflate.obj and trees.obj) updated to version 1.2.5

Changes in unit SynCrtSock
  - deleted deprecated DOS related code (formerly used with DWPL Dos Extender)
  - a dedicated thread is now used if the incoming HTTP request has  POSTed a body content of more than 16 KB (to avoid Deny Of Service, and preserve the Thread Pool to only real small processes)
  - new CROnly parameter for TCrtSocket.SockRecvLn, to handle #13 as line delimiter: by default, #10 or #13#10 are line delimiters (as for normal Window/Linux text files)

Changes in unit SQLite3Commons
    - WriteObject and CopyObject functions now handle Int64 properties, as TJSONWriter.WriteObject method does now also
    - new TSQLRestServerStatic.GetOne and TSQLRestServerStatic.UpdateOne methods,  methods available since a TSQLRestServerStatic instance may be created stand-alone, i.e. without any associated Model/TSQLRestServer
    - diverse fixes in TSQLRestServerStatic which could occur in not expected behavior if security events are enabled for this table (wrong IDToIndex)
    - new TSQLRecordLog.CreateFrom method used to append some log records to an existing JSON log content
    - code modifications to compile with Delphi 6 compiler (Delphi 5 failed due to some obscure compiler bugs in SynCrypto.pas)
    - update SQLite3 engine to version 3.7.3

Changes in unit SQLite3
    - fixed a potential GPF in TSQLRestClientDB.Destroy
    - code modifications to compile with Delphi 6 compiler (Delphi 5 failed due to some obscure compiler bugs in SynCrypto.pas)
    - update SQLite3 engine to version 3.7.3

Changes in unit SQLite3Toolbar
    - allow TSQLRibbon.CreateReport() method not to delete the current content  of the report (useful to specify a custom header/footer before calling
      the default CreateReport implementation)
    - new TSQLRibbon.Refresh method added
    - new AddToReport method to append the specified database Table Content to the report

Changes in unit SQLite3Unit
    - new ForceRefresh parameter to the TSQLTableToGrid.Refresh method

NEW UNIT SQLite3Edit
  - handle an optional caption for the window (by default, the caption is guessed from the record type)
  - handle display without any associated Client/Model/Ribbon, that is allow direct edition of any TSQLRecord child
  - guess the better TGroupBox width on screen for set of enumerates properties

Changes in unit SQLite3Pages
  - fix font color issue in header and footers
  - safety additional code to avoid any division per 0 exception

Online

Board footer

Powered by FluxBB