Dear Experts,


I have an application which is working under Vfp8 with Sql Serevr,
I want to disply the latest updated value in a text box.

For Eg. I want disply the latst updated value of total cash balnace in a text box.

The way i did is that, In click event of Command button i wrote like

SQLExec('ConHand','Select * from TrsTble','Cur_Trs')
Sum(Cur_Trs.Tr_Amt) to Thisform.Text.Value

Using the Timer event i m calling every 1000 minute and refreshing the value

This way is working fine, But when i calling 4 to 5 Tables like this at time,
the processor showing 100% utilisation and results network and
system showng hang till end of the process.

Is there any solution to solve my probs.
Or how can i execute 4 to 5 select statement at a time in single SQLExec() command

Thanks in advance

Abdulla