We help IT Professionals succeed at work.

Procedure Aborts when called From Delphi

Medium Priority
226 Views
Last Modified: 2010-03-19
I have to call a stored procedure from Delphi an from
ISQL/W. Everything was fine until I installed the
MS-SQL Service Pack 2. When I call the SP from ISQL it works fine. When I call it from Delphi the procedure starts an cancels after a few Lines of Code. I get no Error in Delphi.

What can I do to ensure that the stored procedure is executed completely from Delphi?
Comment
Watch Question

Commented:
in delphi you have one parameter the result, in stored procedure you can something like this

begin
 ....


..
 return 1
end

and if the SP worx till end you will get 1 in result

Author

Commented:
My Question was wrong.

I knew that the Procedure is not complete because the there is a incomplete result.

What can be wrong if a Procedure works in ISQL and aborts in Delphi?

Author

Commented:
I adjusted the Points to 220
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.