Re: Union queries and batchoptimistic lock
From: Kovács Ferenc (kovacs_at_quattrosoft.hu)
Date: 02/28/05
- Next message: Ryan: "Multiple Step Operation Generated Errors - Check each status value"
- Previous message: Bill Todd: "Re: Sample for Creating ADO dataset in code..."
- In reply to: Kovács Ferenc: "Union queries and batchoptimistic lock"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 28 Feb 2005 15:26:32 +0100
> 2. Is there a way to correctly post a change into a batchoptmistic
> locked, 'union all' like query (without batching it), perhaps using its
> own recordset object.
Actually, I tried the following:
quADOQuery.Recordset.AddNew(EmptyParam, EmptyParam);
quADOQuery.Recordset.Update(EmptyParam, EmptyParam);
quADOQuery.Resync([]);
which causes a new row to be added to my batchoptimistic query and
actually it stays there (in-memory). However when I try to set any of
the values I get the infamous "Multi-step operation" error. (Actually I
am using persistent fields that I've just generated by using Addfields
in the IDE, with Access2k)
Looking forward for any appriciatable help: Ferenc Kovacs
- Next message: Ryan: "Multiple Step Operation Generated Errors - Check each status value"
- Previous message: Bill Todd: "Re: Sample for Creating ADO dataset in code..."
- In reply to: Kovács Ferenc: "Union queries and batchoptimistic lock"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
