• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Procedure Aborts when called From Delphi

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?
0
AndreasSchindler
Asked:
AndreasSchindler
  • 2
1 Solution
 
odessaCommented:
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
0
 
AndreasSchindlerAuthor 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?
0
 
AndreasSchindlerAuthor Commented:
I adjusted the Points to 220
0
 
ASchindlerCommented:
The Procedure in MS-SQL Server transfers the Count of Each Select Statement to the Client. The installed ODBC Driver has a Problem with the count data from Sql Server SP2.
With SET NOCOUNT=ON in the procedure the Problm is solved.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now