Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Category: Posts

Digital solution partner

Subversion over Ubuntu Server 20.04

Configure svn server over Apache2, using https. sudo apt update sudo apt upgrade   sudo apt-get install apache2 sudo apt-get install subversion libapache2-mod-svn subversion-tools libsvn-dev sudo a2enmod dav dav_svn sudo service apache2 restart sudo mkdir -p /var/lib/svn/ sudo svnadmin create /var/lib/svn/apprepo sudo chown -R www-data:www-data /var/lib/svn sudo chmod -R 775 /var/lib/svn sudo touch /etc/apache2/dav_svn.passwd  …
Read more

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: procedure TForm1.Button1Click(Sender: TObject); var fs: TFormatSettings; begin GetLocaleFormatSettings(LOCALE_SYSTEM_DEFAULT, fs); ShowMessage(‘Actual decimalseparato is:’ + fs.DecimalSeparator); end; If you need to force some…
Read more

Firebird 3 – How to get record number of dataset

How to get record number of dataset using row_number window function with over(). SELECT row_number() over(), t.* FROM test t Example of record number of dataset with even and odd column sorting. SELECT row_number() over(), (CASE WHEN mod(row_number() over(),2) = 0 THEN ‘even’ ELSE ‘odd’ END) AS my_column, custom.* FROM ( SELECT t.* FROM test…
Read more

Ubuntu 20.04 – Massive change of permissions and users to folders and files separately

With bash you can more and more… In linux you can use the “find” command from terminal and execute a command for each result simply. To change all subfolder permission from a folder recursively you can type: find /home/xtr/Desktop/myFolder -type d -print0 |xargs -0 chmod 755 now all falders have the execution permission. To change…
Read more

Delphi 10.4.1 on Android error : java.lang.NullPointerException: Attempt to invoke virtual method

When you try to use the camera component and you get “java.lang.NullPointerException: Attempt to invoke virtual method” only on “release” version of your application, probably you don’t have this setting to true: Check that the Project Options > Entitlements List > Secure File Sharing option is set to true.   good job

Sign Windows Installer with innoSetup

https://docs.microsoft.com/en-us/windows/win32/seccrypto/signtool Create self signed certificate (PTX) in one minute with Delphi: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Creating_a_Certificate_File Deploy your app on Microsoft Store: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Preparing_a_Windows_Application_for_appx_Package_Distribution Sign your installer with your self-signed certificate: https://revolution.screenstepslive.com/s/revolution/m/10695/l/563371-signing-installers-you-create-with-inno-setup Create a verified certificate: https://docs.microsoft.com/it-it/mem/configmgr/mdm/deploy-use/create-pfx-certificate-profiles