Issue
I'm searching for the Firebird equivalent of:
SELECT 'abc' AS abc, 123 AS def, '20110101' AS dt
Whenever I do
SELECT 'whatever' as xxx
I get an error message.
Solution
Firebird, like Oracle, requires a table for a SELECT
.
Usually, RDB$DATABASE
is used for this purpose:
SELECT 'abc' AS abc, 123 AS def, '20110101' AS dt
FROM RDB$DATABASE
Answered By - Quassnoi Answer Checked By - Terry (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.