Results 1 to 3 of 3

Thread: Timing a Query

  1. Oct 18th, 2000, 11:21 AM #1
    ghoff12
    ghoff12 is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    32

    Question

    I am running a query, and i want to stop the query if it taking longer than 20 seconds.

    Does anyone know how i can do this?

    Any info would be great.
    Reply With Quote Reply With Quote
  2. Oct 18th, 2000, 03:11 PM #2
    monte96
    monte96 is offline
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    Use a command object and set the CommandTimeout property
    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    monte96_@hotmail.com
    monte96@vbgarage.com


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..
    Reply With Quote Reply With Quote
  3. Oct 19th, 2000, 02:32 PM #3
    ghoff12
    ghoff12 is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    32
    Ok, well bascially what i wanna do is stop the query.

    If its takes longer than 20 seconds, i want a message box to pop up, and ask if the would like to contineu processing the query. if they click yes, it continues, if no, then will cancel it.

    any ideas how to do this?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width