Re: stored procedure doesn't update records


>I changed my code as you suggested below, but no error was shown. In fact it
>says everything went OK.
>It's funny that the first change in the tables is done, except the second or
>subsecuents. it's like nothing would happen.
>However the next day when the stored procedure is ran from the program, the
>changes are now applied.
>Is there any cache built for the tables in SQL that is not refreshed?
>Do I have to turn off and turn on my pc to get it work? or could be a
>problem from MS SQL?

If you have one or more of the tables that your storedProcedure updates tied up
in a transaction that would keep the changes in your stored procedure from
updating until that transaction is closed.
Are you using explicit transactions in your code?
Are you doing anything stupid like having a transaction open while your
application is in the control of a user?
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Access 2000 & Stored Procedures
    ... Inside the transaction you'll select the record to call, ... >I'm running a application based on Access 2000 and SQL ... >stored procedure with a variable of the agent's ID. ... >record with the agent ID. ...
    (microsoft.public.sqlserver.clients)
  • Re: Writing to exception logs with in a transaction
    ... relative data to some exception log tables in the same database. ... transaction and then the transaction rolls ... I do this in the stored procedure where the exception occurred by passing ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: transaction with unknown nbr of commands
    ... then call your wrapper stored procedure, passing it all of the user ... explicit transaction with a BEGIN TRAN statement, ... >When I run a sqlcommand in a transaction, ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Database updating issue
    ... I started a transaction on the connection class, passed this to the dataadapter, invoked the Update method on the dataadapter and finally commit the transaction. ... try threading the these calls to the stored procedure. ... To accomplish this task, the inserting of all rows, at the moment, I'm using ...
    (microsoft.public.dotnet.framework)
  • Re: SQLServerException: The server failed to resume the transactio
    ... Are you doing transaction management in your stored procedure? ... Can you post your stored procedure defintion, ... If I remove the transaction management code from the proc then everything ... I'm preparing a CallableStatement at the start of the loop and I'm reusing ...
    (microsoft.public.sqlserver.jdbcdriver)