Re: Joined-Sql Updates/Deletes using updateBatch

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 21:07:47 -0400

Hi Jen,

Hi,

Check next KB

http://support.microsoft.com/default.aspx?scid=kb;en-us;250548

pay attention to Unique table dynamic property. Not sure, but it might help
you 

-- 
Val Mazur
Microsoft MVP
"Jen" <anonymous@discussions.microsoft.com> wrote in message 
news:8DC680BE-4D6C-4214-8641-0EB7314E620A@microsoft.com...
> Hi,
>
> I have 2 tables, One is the trasaction table the other is a lookup table. 
> My sql statement is as follows -
>
> SELECT T.Fld1, T.Fld2, L.Fld2, T.fld3
> FROM Transaction T, Lookup L
> WHERE T.PK = L.PK
>
> I create the recordset using the above query and persist it as a dom. My 
> app updates some values in the dom and may also delete a record from the 
> Trasaction table. When I try to update my database, using this dom i.e. -
>
> With rst
> .CursorLocation = adUseClient
> .CursorType = adOpenStatic
> .LockType = adLockBatchOptimistic
>
> .open Source:=dom
>
> Set .ActiveConnection = ctn
>
> .UpdateBatch
> End With
>
> It also tries to update the lookup table and it fails. If the transaction 
> record is deleted, it tries to delete the record from the lookup table 
> also.
>
> Is there anyway to avoid this. Please Help. Thanks in advance.
>
>

Relevant Pages

  • Joined-Sql Updates/Deletes using updateBatch
    ... One is the trasaction table the other is a lookup table. ... My app updates some values in the dom and may also delete a record from the Trasaction table. ... If the transaction record is deleted, it tries to delete the record from the lookup table also. ...
    (microsoft.public.data.ado)
  • "Condition table" query
    ... I have a reference table 'LOOKUP' with 4 fields and sample values as ... Plant Group WorkCentre WageType CalcType ... I need a query which will return all records in the transaction table ...
    (comp.sys.ibm.as400.misc)
  • RE: Way around LEFT OUTER JOIN?
    ... The transaction table, in my original post, will have thousands of rows. ... BTW, I probably should have my clustered PK on the transaction table, and not this lookup table. ...
    (microsoft.public.sqlserver.programming)
  • Re: "Condition table" query
    ... which find a match for a given CalcType in the Lookup table, ... which find any match for a given CalcType in the lookup table? ... I constrained to use procedural logic, examining each transaction ...     and l.group in ...
    (comp.sys.ibm.as400.misc)