General information
Category:
Coding, syntax & commands
Title:
Processor Showing 100% utilization while Excuting Sql Comnd
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only