Via Lattanzio,23 Milano
+39 02 36592025
info@synaptica.info

Blog

Digital solution partner

Firebird SQL – Verify if a string contains digit (number char)

From version 2.5 Firebird introduces the “SIMILAR TO” predicate which allows you to apply a subset of regular expressions in an SQL condition. The documentation of the “SIMILAR TO” predicate is available at https://firebirdsql.org/refdocs/langrefupd25-similar-to.html If we wanted to check if there are numbers (DIGIT) inside a string, i.e. characters from ‘0’ to ‘9’ we could…
Read more

Delphi VCL highlights word in visual components programmatically

Highlights word in a RichView component programmatically:  

How to highlitgh full cell in a DBGrid:

     

How To Use Apache as a Reverse Proxy on Ubuntu 20.04

A reverse proxy is a type of proxy server that accepts HTTP (S) requests and transparently distributes them to one or more backend servers. You can use a reverse proxy to prevent direct access to these underlying application servers. They can also be used to distribute the load of incoming requests to different application servers.…
Read more

Configure Open VPN over PFSense 2.5

Configuring an OpenVPN over pfSense is quite simple. In this video you can see, how to configure a VPN on the lastest release of pfSense using the VPN Wizard.

Subversion over Ubuntu Server 20.04

Configure svn server over Apache2, using https.

  now let’s set the password of the first user:

  configuriamo gli accessi:

  we configure the accesses to the svn folders

  Apache restart:

 

Delphi …. retrive locale format setting

TFormatsettings is record type in Delphi which is used to get or set local information’s like DateTimeFormat, CurrencyFormat, DecimalSeparator etc. wich is declared in System.SysUtils. For Example you need to retrive your current DecimalSeparator:

If you need to force some local settings for conversions you can do for example:

If you want to…
Read more