| Subject | Re: Select without from clausule |
|---|---|
| Author | Adam |
| Post date | 2006-11-02T23:07:24Z |
--- In firebird-support@yahoogroups.com, "yartax1" <yartax@...> wrote:
While you can use
Select 125+56 from RDB$DATABASE
a good tip is to create a table in your database called OneRecordOnly
with a single field, and fill it with a single record (obviously).
Then you can use:
Select 125+56 from OneRecordOnly
That will be a lot more cross database compatible than using
RDB$DATABASE if that is important.
Adam
>As the other 10 people have said, no.
> Hi,
>
> It is possible to run a select query without from clausule in FB 1.5?.
>
>
> Example:
> Select 125+56
While you can use
Select 125+56 from RDB$DATABASE
a good tip is to create a table in your database called OneRecordOnly
with a single field, and fill it with a single record (obviously).
Then you can use:
Select 125+56 from OneRecordOnly
That will be a lot more cross database compatible than using
RDB$DATABASE if that is important.
Adam