mORMot Open Source

Have you noticed that the links that refer to other html files in the documentation don't work?

I guess you have something misunderstood.
Is this on server side or client side ?

I think the documentation it's very very clear.

You can obtain i.e. when calling .ServiceDefine:

var ServiceFactoryServer : TServiceFactoryServer;
    InstanceOfTServer : IServer;
...
ServiceFactoryServer := Server.ServiceDefine(TServer, [IServer], sicShared);
ServiceFactoryServer.Obj(InstanceOfTServer);

If you also want to access to a TSQLRestServer instance simply change class definition by the following

TServer = class(TInjectableObjectRest, IServer)

See Implement your service from TInjectableObjectRest

Note: IMHO your naming in your example it's a little confusing

It's amazing!! Just one word in my language:
B R A V O!!!!

This is great!
Have you any trick regarding remove a column from an SQLite table?

Great!
So what would you specifically improve on this point for a better future understanding and thus improve the current documentation?

Yes Johnnysynop, I read the thread two times,  have you read the answers?

With all my respects to you, I think the first step to solving any conflict for all parts it's to get things clear:

• The work and support given by @ab in this project it's 'UltraExcellent'. Nothing to say. It's not an opinion. It's a fact.

• The definition provided was to get a 'common sense' what is an 'open source project'

• So sorry but I love definitions :-) (extracted from Wikipedia):
  
  In Internet slang, a troll is a person who starts quarrels or upsets people on the Internet to distract and sow discord by posting inflammatory and digressive,[1] extraneous, or off-topic messages in an online community (such as a newsgroup, forum, chat room, or blog) with the intent of provoking readers into displaying emotional responses[2] and normalizing tangential discussion,[3] whether for the troll's amusement or a specific gain.
  

Please, I think it's extra justified that you change the title of this thread.

Many many thanks for your comprehension and have a nice day

Open Source Software definition (extracted from Wikipedia):

Open-source software (OSS) is a type of computer software in which source code is released under a license in which the copyright holder grants users the rights to study, change, and distribute the software to anyone and for any purpose.[1] Open-source software may be developed in a collaborative public manner . Open-source software is a prominent example of open collaboration.[2]

IMHO you should/must to change the title of this thread to be more accurate. Thanks!.

IMHO it's something related regarding some databases drivers needs to free connection in each thread that you create it, therefore you should call 
.EndCurrentThread in each call. Something like this:

...
var SQLDBConnection : TSQLDBConnection;
begin
  SQLDBConnection:=fProps.NewConnection;
  try
    ...
  finally
    SQLConnection.Free;
    fProps.EndCurrentThread;
  end; 
end;
  

But, if I've understood it correctly, why not simply open a port in the office redirected to the server using an httpS protocol (end-to-end encryption as it was designed) and use the mORMot secure RESTful authentication?

What it would be the actual mission of the 'relay' for you?

Hi,
If I'm not wrong, the way to return custom response it's via TServiceCustomAnswer record type.
Please check related section in documentation for further details.

I think this is an issue related with windows firewall or antivirus.
Please, first check locally
· http://192.168.xxx.xxx:8092/<root defined>/timestamp
· or http://192.168.xxx.xxx:8092/<root defined>/mvc-info

then disable firewall and any antivirus and check from another computer same urls.
If it works, create an exception in firewall and enable again, and recheck it.
If the issue persists, please publish the results.

Hope it help

AFAIk, this is valid for a logged user or domain member, but if the domain are not reachable is when ADFS makes sense.

I'm agree @ab that is a nigthmare changing TSQLRecord field...

There is any way to check in SQLite3 if some field has multi-type in a column?
I have some weird behabiours in BLOB fields related to TRawUTF8DynArray for some records only, as you stated.

Any suggestion to intercept wich field I could have changed type in the past and solve the issues?