[firebird-support] Modifying Triggers In Delphi

This may seem like a very naive question, but is it possible to edit the SQL of a trigger from within a programming language (Delphi, in my case). I use IBX components (I know this is not supported, but it seems to work fine!), and I want to periodically update the date condition on one of th

Re: [firebird-support] Modifying Triggers In Delphi

Stefan Thanks very much! Such a simple solution and I did not think of it! I will store my date(s) in a table as you suggest. Thanks, Andrew

Re: [firebird-support] Creating a conditional "order by" statement

Thanks for your reply. I haven't tried it as I came across Tomasz's suggestion first, and that works a treat!

Re: [firebird-support] Creating a conditional "order by" statement

Brilliant! Thanks for your help. I learn something new every day.

[firebird-support] Creating a conditional "order by" statement

I have a stored procedure along the lines of SELECT ID, Amount1, Amount2 .. FROM Table1. UNION SELECT ID, Amount1, Amount2... FROM Table2 ORDER BY 1 Is it possible to construct a conditional ORDER By clause that orders by Amount1 under certain conditions, and order by Amount2