Re: Indicating Stored Procedure progress on Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sylvaine,

Thanks for your reply.

Those sound like two good things to try.

Will let y0u know if I have any success.

Regards,

Alan


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:eGWYiM6IHHA.3872@xxxxxxxxxxxxxxxxxxxxxxx
Two possibilities:

1- You are using the same connection for calling your SP than the
connection used by Access to open the second form. Try opening a
separate
connection to query your table.

2- A transaction is open when the master SP is called, all subsquent
writes are then part of this transaction and won't be visible from the
outside until the transaction is committed. Try the Read Uncommited
isolation level for reading your table (cannot be done for a bound form
under Access, so you will have to directly open a recordset from VBA).
However, I don't know if this will work in your case.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
news:uA7ZwR4IHHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

1. I have a master stored procedure that runs a series of other SP's in
succeession.
2. At the end of each individual SP, I have a command that writes a
record
to a table with the completed SP's name and elapsed time.
3. I want to show this table on a form with the records being added one
by
one as each SP completes.

4. The table-writing methood itself works, but I can't get the form to
requery the underlying form query on this table to display each record
as
it
is added.
5. I tried using the form's OnTimer event together with an interval of
2000,
but nothing happens,

When the master SP completes, the form requeries and the completed
'results'
table displays with all records at once.

Question:
---------

Is there a mthod to get this to work? Am I mising something?

Thanks.

Alan








.

Relevant Pages

  • Re: Indicating Stored Procedure progress on Form
    ... Separate ADO connection than main ADP connection, ... The master SP is also called through a separate connection from the ... SP is being executed through a separate connection. ... writes are then part of this transaction and won't be visible from the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: BeginTransaction helppppppppppppppppppp?
    ... > transaction and "EndSave" method to commit transaction. ... > I wanted to know dose .Net support nested transaction?? ... saving of the detail which are locked by the master. ... which contains the connection and the Sqltransaction object. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Indicating Stored Procedure progress on Form
    ... 1- You are using the same connection for calling your SP than the connection ... 2- A transaction is open when the master SP is called, ... the form requeries and the completed ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Working Transactions somehow started not to work
    ... Transaction and locking are not properties of recordsets but are properties ... Opening a served-based cursor will put a lock on ... If a connection is closed, ... SL> and are not associated necessarily with server-based cursors. ...
    (microsoft.public.access.adp.sqlserver)
  • Setting Locks on Rows in MSSQL Database (Currenlty Unsolvable Problem and Trying)
    ... I am beginning a transaction from PHP and setting a lock on a record ... I then commit the transaction I started when the user clicked ... There is no way in PHP where I can start a persistent ms sql connection ...
    (alt.php)