Interrupting a long SQL Server database access from VB
Posted on 2001-07-09
This is a 'standard' problem but have not seen a specific
example that I can just copy that does actually work
User interface has a list of reports for user to pick and display with Crystal reports. Selecting report causes
an SQL stored procedure to be called to build the data of
say 50 to 100,000 records and display the report.
Problem: Data access times out.
Required: Ability to press ESC key or some other specific user interface key/button and exit from the fetch cycle gracefully.
Have tried DoEvents but with no success