Hi,

> How can I select from one table and limit results to one record.

By reading the Fb1.0 release notes.

It mentions:

SELECT FIRST 1 [SKIP n] * FROM MYTABLE


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> select * from MyTable where MyTable.MyColumn = Something
>
> In MySQL I am using LIMIT 1 but in firebird it is not working.
>
> --
> Aleš :)
>
> + http://www.curk-sp.si