[Firebird-net-provider] [Firebid-net-provider] TableMappings

[Martin R. <ne...@mi...>]

Hi,
I need use fbDataAdapter mappings, but Ii can't work.
This is my code:

LUCTY is table in database
UCTY is table in dataset

daFill.TableMappings.Add("LUCTY","UCTY");
daFill.TableMappings["LUCTY"].ColumnMappings.Add("coUcet","UCET");
daFill.TableMappings["LUCTY"].ColumnMappings.Add("coPopis","POPIS");
FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY";
daFill.Fill(dsLookup,"UCTY");

After this I get in result table with 4 columns coUcet,UCET,coPopis,POPIS.
Is it a bug or I do something wrong?

And one question moore.
How I can make Command for make more than one datatable?
Like
FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY; SELECT ABC ,DEF FROM
LTABLE";

Best regards Martin Radvansky