Synopse Open Source

2010-01-14

Synopse SQLite3 Framework version 1.1

By AB4327-GANDI, 2010-01-14. Open Source › mORMot Framework

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.

one comment no trackbacks

Updated Enhanced System Run Time patches

By AB4327-GANDI, 2010-01-14. Open Source › Enhanced Delphi Run Time

Delphi

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.

one comment no trackbacks

2010-01-05

New Enhanced System Run Time Distribution

By AB4327-GANDI, 2010-01-05. Open Source › Enhanced Delphi Run Time

Delphi

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.

one comment no trackbacks

Synopse SQLite3 Framework: NULL handling

By AB4327-GANDI, 2010-01-05. Open Source › mORMot Framework

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

one comment no trackbacks

Synopse SQLite3 Framework: why ORM?

By AB4327-GANDI, 2010-01-05. Open Source › mORMot Framework

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;

one comment no trackbacks

2010-01-01