How to get record number of dataset using row_number window function with over().
|
1 2 3 4 |
SELECT row_number() over(), t.* FROM test t |
Example of record number of dataset with even and odd column sorting.
|
1 2 3 4 5 6 7 8 9 |
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 t ORDER BY t.description ) custom |
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:
|
1 |
find /home/xtr/Desktop/myFolder -type d -print0 |xargs -0 chmod 755 |
now all falders have the execution permission. To change all files permission from a folder recursively you…
Read more
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
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
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
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”. On Indy Server the error is: “EIdOSSLCouldNotLoadSSLLibrary: Could not load SSL library”. This problem is caused because Indy does not suppurt the lastest version of openSSL library. To avoid this…
Read more
