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
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
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
Remode Manager is a particular Web Server that lets you send commands to your Android device . All commands are interpreted by Remode simple http API . Among these controls are also APIs to read and write to a serial cable OTG . It is full done with Delphi 10Seattle except for an Extrnal jar…
Read more
BestWishesfor a happyXmas and a 2016full of ideas and projects! TeamSynaptica
