[Firebird-net-provider] select first 1 * from tableA doesn't show result

[benny <be...@ch...>]

Hi,

   I am using firebird.net data provider 1.6 Beta, I could load the data =
to datagrid using sql:  select * from tableA where it show more than one =
row in the datagrid. But, currently I want to have result of one row =
using  select first 1 * from tableA where this is a valid sql statement =
while trying on Firebird1.5 final release...
   What I had miss out?  Or what other ways I could reach my purpose by =
having first row on my datagrid?

my code was=20
   ....
    FbDAdOrder.SelectCommand :=3D FbCommOrder;
    FbDAdOrder.Fill(dsOrder, 'TempInfo');
    DataGrid.DataSource :=3D dsOrder.Tables['TempInfo'];
    DataGrid.DataBind;
where  FbDAdOrder is FbAdapter and FbCommOrder is FbCommand ..

TIA=20

regards,

benny :)