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

Category: Posts

Digital solution partner

Happy Women’s Day!!!

Make your launcher app in Android

Yesterday I found a simple application with Delphi source , here , that allows you to manage and search the applications installed on your Android device . To which I got the idea of ​​trying to make a launcher for Android using a IMX6 card ( Cortex A8 ) to do the test. The thing…
Read more

Firebird SQL & Interbase list of all foreign keys

With that simple peace of code you can retrive the full list of all “FK” Foreign Key of an Interbase or Firebird DB. SELECT rc.RDB$CONSTRAINT_NAME AS constraint_name, i.RDB$RELATION_NAME AS table_name, s.RDB$FIELD_NAME AS field_name, i.RDB$DESCRIPTION AS description, rc.RDB$DEFERRABLE AS is_deferrable, rc.RDB$INITIALLY_DEFERRED AS is_deferred, refc.RDB$UPDATE_RULE AS on_update, refc.RDB$DELETE_RULE AS on_delete, refc.RDB$MATCH_OPTION AS match_type, i2.RDB$RELATION_NAME AS references_table, s2.RDB$FIELD_NAME…
Read more

synaptica@lunch

TIPS for developing Delphi 10Seattle Apps on Apple environment

With Delphi 10Seattle can easily create beautiful applications for Mac OSX and iOS , it will be biased but The Delphi IDE is now truly exceptional ; First you need to configure the development environment , installing everything you need as well documented by Embarcadero . Once your environment is functioning well , this does…
Read more

The Haversine formula in Firebird SQL => Calculate distance between two WGS84 Points

Hi, I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure. This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth). You can call the procedure like this: SELECT * FROM HAVERSINE_GENERIC(1, 45,474081, 9,179348, 45,456091, 9)…
Read more