selas
asked on
ProgressBar + Query
I have big query (20s to open) and i want to run progresbar while opening query?
ADOQuery5.SQL.Clear;
ADOQuery5.SQL.Add('select krupje, sum(skirtumas), sum(viso) from (select krupje, skirtumas, viso from bchipsai where krupje is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24 union all');
ADOQuery5.SQL.Add('select inspektorius, skirtumas, viso from bchipsai where inspektorius is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24 union all');
ADOQuery5.SQL.Add('select chiperis, skirtumas, viso from bchipsai where chiperis is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24) group by krupje');
ADOQuery5.Open;
How to do it?
ADOQuery5.SQL.Clear;
ADOQuery5.SQL.Add('select krupje, sum(skirtumas), sum(viso) from (select krupje, skirtumas, viso from bchipsai where krupje is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24 union all');
ADOQuery5.SQL.Add('select inspektorius, skirtumas, viso from bchipsai where inspektorius is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24 union all');
ADOQuery5.SQL.Add('select chiperis, skirtumas, viso from bchipsai where chiperis is not null and skirtumas is not null and laikas > trunc(sysdate)+8/24) group by krupje');
ADOQuery5.Open;
How to do it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.