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

Author: Ivan Revelli

Digital solution partner

Firebird 3 – How to get record number of dataset

How to get record number of dataset using row_number window function with over().

Example of record number of dataset with even and odd column sorting.

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:

now all falders have the execution permission. To change all files permission from a folder recursively you…
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    

Firebird 3.0.7 Embedded with Delphi & Firedac

Unlike Firebird 2.5, Firebird 3 does not need a different DB connection library. In Windows, until today to distribute embedded Firebird fbembedd.dll was used instead of fbclient.dll, now with Firebird 3.0 fbclient.dll is always used both for the connection to a Firebird server and for the management of embedded / local DBs. In firebird the…
Read more

Delphi 10.4.1 Indy SSL on Ubuntu 20.04

If you deploy your FMX application on Ubuntu 20.04 and you are using indy ssl interceptor, you will get “Could not load SSL library”. This problem is caused because Indy does not suppurt the lastest version of openSSL library. To avoid this problem you can compile by your self the SSL libraries ver. 1.0.2u that…
Read more