Steven Howes wrote:
> Hi Everyone, I'm in the middle of debugging a VB app that calls a stored proc. The stored Proc checks tables and under certain conditions copies records to another table. Depending on where I run the stored Proc from I get a different number of records copied.
>
> VB - 0 records Copied.
> Toad - 6 records copied.
> SQL navigator - 0 records copied.
> SQL Worksheet 6 records copied.
>
> I've checked the data and the code and the correct answer is 6. Anyone have any ideas why this would happen?
>
> Steve.
None. Nor is any help possible given what little you've told us.
My guess ... the userid for Toad and SQL Worksheet is different
than what is being used with SQL Navigator and VB.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue May 24 2005 - 12:23:05 CDT
