mORMot Open Source

Hi,

I'm trying to use TSQLRecord.CreateAndFillPrepareJoined() method to automatically create nested objects, but I don't understand the method parameters.
Neither in the whole Mormot documentation nor in the forum there is a complete and explicit example of this method.

In CreateandFillPrepare the SQL 'WHERE' clause with its parameters is easy to understand and straightforward.
In CreateAndFillPrepareJoined there are aFormatSWLJoin, aParamsSQLJoin and aBoundsSQLJoin parameters.
Do these mean that to call this method an explicit SQL JOIN clause is needed?
If yes, how should I write such clauses?
And if we must write explicitly the SQL JOIN instruction, doesn't it negate the concept of automatic nested object creation which should be the scope of this method?

Thanks.

Hi,

very long time since my first post here.
After three years I updated mORMot files in Delphi 2010 Pro and tried to run TestSQL3.dpr to check everything is ok but I got the error in subject: [DCC Fatal Error] SynMongoDB.pas(6119): F2084 Internal Error: URW1111

The editor pointed to an empty source row in SynMongoDB.pas and after many searches in Google about Delphi compiler error F2084 I didn't find any helpful information.

I don't know if this matters, but few months ago I updated SO going from Window 7 to Windos 10 and since then I never used mORMot: by the while, I had no problems with all my other Delphi projects and third part libraries in the meantime.
The previous version of mORMot was working and passed all test in Win 7.

I disintalled and reinstalled Dephi with all Embaradero patches, Andy's DevExtensions and IDE Fix Pack, checked all library and search mORMot paths in Delphi options but I still get the same error.

No particular conditional define in project options: maybe I'm missing something, any clue about this problem?

Thanks.

Hi all,

first message here.
Today I downloaded the last sources and installed mORMot for the first time.
I'm using Delphi 2010 Pro but after following all instructions (unzip, library path, SQLite3*.obj files, etc.) I tried to compile the TestSQL3 project but I got an error.
I read the documentation (very good and complete! ), searched the forum, the blog, the code comments but I didn't find any help about this problem.

This is the code that causes the error:

{$ifdef ISDELPHI2010} // Delphi 2009 generics support is buggy :(
function TSQLRest.Service<T>: T;
var service: TServiceFactory;
begin
  service := fServices.Info(TypeInfo(T));
  if (service=nil) or not service.Get(result) then
    result := nil;
end;
{$endif}

Delphi says '[DCC Error] mORMot.pas(20736): E2010 Incompatible types: 'T' and 'Pointer', pointing to the line 'result := nil;'
I didn't define any strange complier directive on my own.
I tried also to compile without directive ISDELPHI2010 in Synopse.inc, but I got the same error.

Then I Googled a bit and I found on StackOverflow this answer.
So I changed
'result := nil;'
to
'result := Default(T);'
Now I can compile, run TestSQL3.exe and pass all the tests.

The question is: is it a safe change?
I don't use Generics in Delphi, so I'm pretty lost with the Generics incompatibility types error message.

Thank you in advance.