January 2010 (10)

2010-01-24

SQLite3 Framework updates and Samples

The SQLite3 Framework has been updated. Three sample applications are provided, in order to show basic ORM features of the framework.

Continue reading

2010-01-22

Synopse Enhanced Framework version 1.3

The version 1.3 of the Synopse SQLite3 Framework is just released. It's a minor release, with bug fixes, especially for Delphi 2009/2010.

Continue reading

2010-01-18

Synopse SQLite3 Framework version 1.2

The version 1.2 of the Synopse SQLite3 Framework is just released. Includes latest SQLite3 engine version 3.6.22. Now tested on  Delphi 7, 2007 and 2009, it should work on all Delphi compiler versions from 3 to 2010.

Continue reading

Enhanced System Run Time for Delphi 7 and Delphi 2007

 I managed to get our RTL work with Delphi 2007. Only System.pas and SysInit.pas are supplied (and needed) for Delphi 2007. Even if some John O'Harrow or Pierre Le Riche modifications were already included in Delphi 2007, some of my tricks are unique and could be useful even on this compiler.

Continue reading

2010-01-14

Synopse SQLite3 Framework version 1.1

The version 1.1 of the Synopse SQLite3 Framework is just released. Includes latest SQLite3 engine version 3.6.22. Delphi 3 to Delphi 2007 compatiblity, first attempt to compile under Delphi 2009/2010 and FPC.

Continue reading

Updated Enhanced System Run Time patches

It did appear that some diverse VCL source code files were provided, with the same official version. So I made some diverse patches, in order that everyone could get our enhancements.

Continue reading

2010-01-05

New Enhanced System Run Time Distribution

Tonight, I received an email from Nick Hodges, the Delphi Development Manager, about our distribution of some corrections/enhancements of the Delphi 7 System and VCL source code.

Continue reading

Synopse SQLite3 Framework: NULL handling

Question posted in the embarcadero forum:

Is there a way in your wrapper to know whether the field is NULL (say, Integer or String field)?
In most databases '' and null are different values.
Thanks,
Michael

Continue reading

Synopse SQLite3 Framework: why ORM?

In the codegear forum, I posted this example code, to illustrate the Object-relational mapping (ORM) aspect of the framework :

People := TSQLPeople.Create;
try
  People.Name := 'Smith';
  People.Address := 'New York City';
  People.BirthDate := Now;
  ID := Client.Add(People);
finally
  People.Free;
end;

Albert Drent posted this question:

What's the advantage above the usage of SQL?

with MyQuery do begin
   sql.text := 'insert into people values ("Smith","New York City","2008-01-01")';
   execSQL;
end;

Continue reading

2010-01-01

Synopse SQLite3 Framework installation

Some details about the current framework status, and the fact that it does compile only under Delphi 7 by now.

Continue reading