Re: ADO And SQL server 200O

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/10/05


Date: Wed, 09 Mar 2005 22:16:05 -0600


>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?

Seems to me that using locktype BatchUpdate on a TadoDataset will give you all
these capabilities

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com