Page 1 of 1

Exchanging specific commands in SQL Firebird/Postgres

Posted: Tue 20 Oct 2015 14:17
by soyjoy
My dear , I'm using Unidac in my application in Delphi 7 to access my database , which can be in Firebird or Postgres .
I wonder if like me change within a UniQuery SQL containing specific functions of a bank (EXECUTE BLOCK firebird for example).

And as a legacy system , there is already widely in use system "Execute block" and I wonder how in exchange for a similar PostGres .
Thank you in advance for all .

Re: Exchanging specific commands in SQL Firebird/Postgres

Posted: Wed 21 Oct 2015 09:08
by azyk
You can replace code blocks in the SQL query that are specific for Firebird/PostgreSQL using UniDAC macros. See more details in our documentation: https://www.devart.com/unidac/docs/?unisql.htm