Hellen

vLista base SQL is: select * from kredyty_od(:d1,:d2,:waluta)
where kredyty_od is select procedure.

I added

SQL.Clear;

>> ShowMessage(vLista.ServerSQL);

InternalDataset.AssignSQLWithSearch(vLista) ;

>> ShowMessage(vL.SQL.Text);

vLista.ServerSQL contains all search criteria (all neccessary where clauses)
, then after assigning vL.SQLText shows base sql statement but parameters
for procedure are assigned correctly.
I wonder why after assigning vLista goes into search mode. Maybe then all
where conditions are cleared and vL receives only base statement with param
values?

Marcin