| Subject | Re: [firebird-support] Port MySQL to Firebird - SQL syntax - can I do this? |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-07-11T01:32:29Z |
At 12:47 AM 11/07/2003 +0000, you wrote:
for Premium.
A much safer and more elegant way to handle this would be to write a
selectable stored procedure to calculate and output the whole set. This
would avoid placing the burden of this complicated specification in the SQL
string management that different applications would otherwise have to
manage independently each time it was wanted.
heLen
>Hi all,No, but 1.5 has CASE and COALESCE which would possibly get you to a result
>
>Presently I have an app with MySQL as backend and use a sql statement
>that has 'if's in them, does Firebird/Interbase support this?
for Premium.
A much safer and more elegant way to handle this would be to write a
selectable stored procedure to calculate and output the whole set. This
would avoid placing the burden of this complicated specification in the SQL
string management that different applications would otherwise have to
manage independently each time it was wanted.
heLen