KenR

I have been doing my own replication using NexusDB for years. Basically in the application there are triggers for each table that needs to be synchronised which inserts a record for every field changed into a simgle table, the data itself is not recorded at this time. There is a flag for the type of opertation e.g. update, delete, etc. There is a service running at each site that every minute, if there are any entries in the table, processes the records into a new table with the data, zips the table and uploads it by FTP to a central site. The same service, running at another site downloads the zip and applies the changes. Obviously there are many safeguards that need to be applied during each stage. This may seem rather Heath Robinson but it has been working flawlessly for a long time.

e.g. {$IF DEFINED(IOS) or DEFINED(ANDROID)} FDConnection.Params.Database:=TPath.Combine(TPath.GetDocumentsPath,'xxx.db'); {$ELSE} FDConnection.Params.Database:=ExtractFilePath(ParamStr(0))+'xxx.db'; {$ENDIF} FDConnection.Connected:=True;

I'm retired!

An unlimited amout as I don't charge myself!

Seems rather expensive!

Good to hear as I use indy a lot and it works perfectly for me. Thanks Remy for your continued involvement.

I didn't realise Indy was not being updated. I have used it since it first became available. I feel I need to move away, but what to?

I will try it on one of them. 11.0 had huge problems.

10.4.2 crashes several times a day on large projects for me. I have not yet been brave enough to try them in 11.1

I can connect fine using Indy and TLS 1.2 so please show your code.

Make sure you override the default registry settings e.g. something like RestClient.SecureProtocols:=[THTTPSecureProtocol.TLS12,THTTPSecureProtocol.TLS13];

Does anyone know if there is an application available to generate all iOS, Android, etc. images from a single image and also update the project file. I ask because I have written one and am considering making it freely available.

Now available on GetIt without the need to run my installation program.

Not sure how you are using this but using time rather than now will give you problems if starttime/endtime spans midnight.

Great. Pleased I could help.

Do you have the CreateDatabase param set. e.g. FDConnection1.Params.Values['CreateDatabase']:=BoolToStr(not FileExists(FDConnection1.Params.Database),True);

Does anyone know if TNetHTTPRequest automatically generates a request_id and if so can it be modified in 10.4.2?

No. It was for integration with a property portal. They were returning a request_id but I was not providing one so was interested in knowing where it came from. Further investigation revealed that they were always returning the same one for each property so looks like they are creating it themselves!

I don't know how anyone can live without DevEx!

Yes I could but have chosen not to on the basis that there are very probably other major bugs in D11 at this stage.

I am certainly waiting for a major bug to be fixed relating to TRESTRequest before I can use D11 in production. See https://quality.embarcadero.com/browse/RSP-35341

TMS have one see https://www.tmssoftware.com/site/tmsmqtt.asp

Lars suggestion on creating DB in appdata only if the DB does not already exist is the easiest way forward.

GetIt just downloads the latest setup from my server so the version displayed in getit is not accurate. I am talking to EMBT about a possibly different way of doing this but they have not replied yet. I considered possibly having 2 different locations for DB. Jury is still out 🙂

I do normally install databases/inii files to appdata\roaming but as this application started out just for my use I took shortcuts. Now I'm going to have to copy existing databases. Oh well, that's what I get for being lazy!