I'm calling my stored procedure through a lookup in my activex code ,but it
gives me this error:
The statement has been terminated

When I call the sp from outside (for isntance from Query Anakyzer) it
works,but in DTS it dosen't

Hey RayAll!
Stored procedure doesn't work in lookup query.
Did it ever work and just stopped working, or it never worked?

--
Simon Worth


"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Simon,

Storedprocedures work in lookups,why not? It might not be an efficiant way
,but it works.The reason it didn't work for me is that if there is for
instance a ForiegnKey violation,there is no way of knowing that and you get
this error message."The statement has been terminated".That might be a good
reason not to use sp in your lookups ....


Anyway,Thanks for yuor help.

Ray
"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote

no, I wasn't saying it wouldn't work, I was just restating what you said to
make sure I was clear.

--
Simon Worth


"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Excellent,
Ray
"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote