Hi All,
We have an app. developed in VFP 6 and we are using terminal server to run the application. We have a batch update utility to update the required masters. Till date this form for update was running perfectly fine without any problems. Lately whenever we are running this form it restarts the server without any message or any error message. This happens even if we r running compiled exe version or from VFP command window level. When we tried to debug it we found that we have issued an sql command e.g.
The whole code is as below :
Sele Mastertable
Go top
Scan
sele * from abc where abc.mastercode = Mastertable.code into curs xyz
Select Xyz
Sele Mastertable
Endscan
Now the problem is the moment we issue Select xyz the machine seems to restart and this happens only after executing certain records from mastertable. E.g. if mastertable has more than 1000 records then it works fine till 800 or 820 records and then when we issue Select xyz table the machine restarts.
any help is highly appreciated.
TIA
Shailesh.