Update Resync not working

Article View: borland.public.cppbuilder.database.ado

Article #4242

Back to borland.public.cppbuilder.database.ado Previous Next

#4242

From: Tony
Date: Sat, 02 Mar 2002 11:15

7 lines
1477 bytes

I convertied an Access 2000 db to MS-SQL server and now the ADO dynamic
property "update resync" does not work. If I set adResyncAutoIncrement, the
auto inc ID fields contain 0 in the after post event. If I set
adResyncInserts, the record disapears from the record set when posted and
does not re-appear unless you close/open the recordset. This is true for all
tables in the database. I have another MS-SQL database on the same machine
and same server that works fine. Thanks for any help.

Technical Details

Message-ID: <3c80b3af_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news-hog.berkeley.edu!ucberkeley!enews.sgi.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2a04f1052edacbc8,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-02 03:14:42 PST
From: "Tony" <hse@hill-soft.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Update Resync not working
Date: Sat, 2 Mar 2002 06:15:30 -0500
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 165.121.210.58
Message-ID: <3c80b3af_2@dnews>
X-Trace: dnews 1015067567 165.121.210.58 (2 Mar 2002 03:12:47 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news-hog.berkeley.edu!ucberkeley!enews.sgi.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews