mORMot Open Source

Ok, the code.

	FModel := TSQLModel.Create([TModelUser]);
	VirtualTableExternalRegister(FModel, TModelUser, FOwner.ConnectionProperties);
	FServer := TSQLRestServerDB.Create(FModel, SQLITE_MEMORY_DATABASE_NAME);
	GetRestServerDb.CreateSQLIndex(TModelUser, ['UserName'], True);
	GetRestServerDb.CreateMissingTables;

Where FOwner.ConnectionProperties is a connection property to postgresql server.

When i try to create the index i get:

Project Shell.exe raised exception class ESQLite3Exception with message 'Error SQLITE_ERROR (1) using 3.8.9 - 'no such table: main.ModelUser' extended_errcode=1'.

Is this a known issue?

Thanks in advance.

------

Solved:

Just reverse the last two lines. ;)

Hi there again.

Since mORMot handles fields by published properties i got another question, it is possible to add to the mORMot kernel fields at runtime (i will just provide the size/memory for it).
Or is there a builtin funcionality available for such cases?

Thanks in advance.

Hello,

I`m trying to investigate how should i handle connection errors code. Especially with postgresql such as bad database name, invalid user password etc. Any advice? The exceptions doesnt have any code errors just, a message, wich can be either in English or other language depending on pgsql so its not a good way to check it. ZdbcPostgreSqlUtils: CheckPostgreSQLError

Thanks in advance.