mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

SQLite3: User Defined Functions and "has many" relationships

Two major update of the SQLite3 framework, just uploaded to our source code repository - see http://synopse.info/fossil/info/d9f6c60c40

1. now handles User Defined Functions, via sqlite3_create_function_v2 and corresponding sqlite3_result_* functions: as sample, the MOD() function is defined in any database opened via TSQLDataBase (it was needed to have compatibility with Oracle/MySQL/MSSQL/PostGreSQL engines for our TSQLRecordMany implementation)

2. new TSQLRecordMany to handle "has many" and "has many through" relationships

More to come about this "has many" new feature...

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: SQLite3: User Defined Functions and "has many" relationships

More details, source code and analysis of the "has many" feature is available in http://synopse.info/forum/viewtopic.php?id=142

See also the dedicated blog entry, at http://blog.synopse.info/post/2010/10/2 … ationships