January 25, 2002 at 6:39 am
I have a simple vb app that I use to allow users to update information in a database using stored procedures. The app calls three stored procudures when the user requests an update. It goes through the first two fine, but on the third one it is failing for some reason. Is there something I should be checking for?
January 25, 2002 at 7:20 am
I found out what the problem was.
January 25, 2002 at 10:02 am
Mind updating us? It's nice to have a followup so others who search these forums can see the resolution.
Steve Jones
January 25, 2002 at 10:07 am
The stored procedure was getting caught on one of the queries. It was not processing due to an alias issue. This actually happended before, and I'm not sure why it does happen. I use alot of views to update my data, and whenever I change something in my view I usually get error message 107 stating the Remote 1003 doesn't match a table or alias in the select statement. So, I change which table the parameter value needs to be equal to. There may be a greater problem, but I don't know if there is.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply