Re: Delay

"[MSFT]" wrote in message news:dhC$fHMkFHA.2700@xxxxxxxxxxxxxxxxxxxxxxxx
: It is better to use same connection to read and write the record so that
it
: can know the changes in database right way. Also, we should use the
: adOpenDynamic and Server side cursor to get "fresh" data in the database.

Hi Luke...

Thanks for responding.

Are you telling me as long as I use adOpenDynamic this is not an issue? I
have heard that SQL will return control to ASP when it feels everything is
correct but may not be finished processing the data. If I think choose to
try to get the last record, it may not be available. Are you debunking
that?

Please elaborate on the server-side cursor.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp


.

Relevant Pages

  • Re: Server LogIns without db roles
    ... is to use the cursor since there is no entry in the sys.database_principal ... | database on the server into a single view without using a cursor (some ... |>As to your other concern abou the single user mode, ... |>will not use the corresponding database if some one is using it. ...
    (microsoft.public.sqlserver.security)
  • Re: Server LogIns without db roles
    ... >This is Jiayi from Microsoft SQL Server team. ... >Just for your information, sp_MSforeachdb is implemented using the cursor, ... >As to your other concern abou the single user mode, ... >will not use the corresponding database if some one is using it. ...
    (microsoft.public.sqlserver.security)
  • Re: database persistence with mysql, sqlite
    ... records without reestablishing a database connection every time I ... left from the initial query. ... open cursor can lock-out writers, ... mod_python (Python Server Pages under Apache). ...
    (comp.lang.python)
  • Re: MS Best Practice - Load subset of a single Row
    ... I meant - stay away from writing your own cursor. ... But I'm gonna try and stay out of optimizing your database. ... dynamic SQL to fetch the data you need. ... > the db server cache most of the time, ...
    (microsoft.public.dotnet.framework.adonet)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)