ADO And SQL server 200O

From: Ken Lange (langekg_at_cox.net)
Date: 03/09/05 

Date: Wed, 09 Mar 2005 14:36:02 -0800

I have an interaweb frontend that I use against an SQL server. I need
to check the data for completeness before posting it to the permanent
table. Right
I have my databound controls connected to a temporary table, and when
the user saves I check it for completeness before doing an update to the

permanent table. My problem is when I try to clean up my user's
record(s) in the temp table, if another user has a record in the temp
table, record
locking is hold ing up my delete. I am using optimistic locking, but my
DBA says that it is still keeping me from inspecting records to
determine if they
should be deleted. Can I adjust my ADO components to not cause a lock on
the table, or is there another way.

I thought about using a clientdataset, but I can't figure how to load it
from the provider's dataset, deactivate the provider's dataset,( to
clear the lock)
while keeping the client dataset active, do the editing, (even check the
data in the data set and forego the temp table maybe?) and then
reconnect to the provider's dataset and then apply updates; I thought
this should be possible, but I can't find out how to do it. If this is
possible can someone show me the sequence of commands to do it?

Thanks.

Relevant Pages

  • Re: OT - How temp agencies work
    ... I used temp. ... Sometimes a permanent job can come out of it, ... agency I work for. ... The bulk of our business came from positions like ...
    (rec.crafts.textiles.quilting)
  • Re: Way OT Query...
    ... to reign in the use of temp services. ... workforce *instead of* a group of full time workers. ... employee (and also risk the extra expenses of having to terminate someone ... if the choice was permanent position or defer the work uhntil a later time, ...
    (rec.arts.sf.tv.babylon5.moderated)
  • Re: Create Table Permission for Domain Users Group
    ... Rob, ... > Are there any upsides to temp tables from a performance point of view ... Temp tables are written to the tempdb database. ... your code if your "temporary" permanent tables still exist. ...
    (microsoft.public.sqlserver.security)
  • Re: Avoid Creating Auto Number Field
    ... > Don't use a temp table. ... > validate the entered data and then add a new record to your table using ... A temp table which matches the layout of the permanent table is ... >> having the auto number field designated as an auto number field in the ...
    (microsoft.public.access.formscoding)