Article View: borland.public.cppbuilder.database.ado
Article #4160Re: Update Resync not working
From: Tony
Date: Wed, 06 Mar 2002 00:48
Date: Wed, 06 Mar 2002 00:48
20 lines
1655 bytes
1655 bytes
PSS: I solved the problem by using separate ADOConnection objects for client side and server side cursors. Anyone have any more info or links to explain this behavor? "Tony" <hse@hill-soft.com> wrote in message news:3c80b3af_2@dnews... > 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:
<3c8566cf_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news-out.visi.com!hermes.visi.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c80b3af_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,2a04f1052edacbc8 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-05 17:05:22 PST From: "Tony" <hse@hill-soft.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3c80b3af_2@dnews> Subject: Re: Update Resync not working Date: Tue, 5 Mar 2002 19:48:52 -0500 Lines: 22 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.212.183 Message-ID: <3c8566cf_2@dnews> X-Trace: dnews 1015375567 165.121.212.183 (5 Mar 2002 16:46:07 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news-out.visi.com!hermes.visi.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews