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
Xtumble library for Delphi Xtumble4Delphi is native delphi library, cross platform ( Windows, Android, iOS, macOSX, Linux64) that allow you to integrate all cloud functonalitty of the XTumble platform in your application. If you create an XTumble Account you can have a dedicated ERP, e-commerce, Cluod Drive, CRM Mail with SMTP and POS system in the cluod. Creating an…
Read more
