Re: Help on resolving record conflicts with ADO

Additional note:

I tried my query in enterprise manager. If I create 2 query windows with
the same query/data in both window and update a value in one and post, when
I try to change the same row/column in the 2nd window I get all kinds of
strange results. Perhaps it's a problem with the basic concept of my select
statement.

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:00ssv11sqijdu9uih7tsklldsco1midgtq@xxxxxxxxxx

An additional note on this issue:

I've been doing testing for several hours since my original post. It
seems
that if I whittle down my original sql statement to just 1 table, the
conflict-resolution code I have in my PostError event works. So that
leads
me to believe that there's a problem with uniqueness with my query. The
odd
thing is that the query simply tacks on 1 field from another table - I'm
left outer joining the other table, and incidentally there can only be a
max. of 1 joined records per primary table. I'm using the key from the
primary table in the query.

I've also tried BetterADO, but it has not helped get passed my section of
code for re-syncing. I may not be using it properly, but I was reading
somewhere that setting the Primary Table property (something like that) in
the control (BetterADO) would eliminate any question about which table was
the primary table, so any updates on that table should work properly.

This may help - it seems that even though I'm specifically setting
['Update
Criteria'].Value := adCriteriaKey, when I do Action := daRetry I am faced
with the exact same PostError problem. It's as if the setting of the
update
criteria didn't take.
Does you code work if you leave off the Resync?
If it does than I think you may need to add a Resync Command
Joins don't resync properly with out a Resync Command
TbetterADODataset has the Resync_Command property to make this easy to do.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Re: Help on resolving record conflicts with ADO
    ... BetterADO with no success. ... conflict-resolution code I have in my PostError event works. ... me to believe that there's a problem with uniqueness with my query. ... If it does than I think you may need to add a Resync Command ...
    (borland.public.delphi.database.ado)
  • Microsoft Cleanliness
    ... I guess I've been working with A97 too long. ... In the database window they added a couple of wizards to clutter it up instead of. ... MS preceeds each table with the word TABLE and each query with "QUERY". ... I guess MS programmers have never heard a dropdown can have more than one column. ...
    (comp.databases.ms-access)
  • Re: Mailmerge from Access
    ... Query linked to the Access db. ... > manipulate the z-order (i.e. which window in front of which) will work. ... >> So the problem is that the queries parameter window opens up first, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Microsoft Cleanliness
    ... In the database window they added a couple of wizards to clutter it up instead of. ... MS preceeds each table with the word TABLE and each query with "QUERY". ... Somebody at MS had common sense at one time and allowed you to select from Table, Query, or both in A97. ...
    (comp.databases.ms-access)
  • Re: Exporting numbers to a text file with more than 2 decimal digi
    ... the correct name and not modify the grid in the bottom half of the window. ... The Database is called GNSW_P756DEM. ... Double clicked on "Create Query in Design View" ... In the Field cell for the 2nd column, ...
    (microsoft.public.access.externaldata)