Hi Ed, Sounds like you might want to try and run your procedure in a thread. i just reread an article in Visual Dev sept/oct 98 by Eric Harmon with a similar issue.
Cheers, Charlie ----- Original Message ----- From: edsynergy To: [email protected] Sent: Saturday, April 26, 2008 1:47 AM Subject: [delphi-en] mssql stored procedure Hi, I am using D7 enterprise. I have created a stored procedure in mssql that fires off from the delphi app. When I test run the procedure in mssql Enterprise it runs fine and takes about 90 seconds to complete. When I run it from the app it locks up. The application goes into 'not responding' when viewed in the taskmanager. Is there anyway of keeping it 'awake' whilst the stored procedure is run. Ed [Non-text portions of this message have been removed]
