Article View: borland.public.cppbuilder.database.ado
Article #3187Re: BCB6 Issue - Setting an ADO recordsets properties
From: Mark Guerrieri
Date: Tue, 03 Dec 2002 06:09
Date: Tue, 03 Dec 2002 06:09
67 lines
3195 bytes
3195 bytes
This is a known issue with ADO is BCB6 - you search google groups to find
various workarounds- what I do is this (not sure of exact syntax/class
names, but you get the picture):
_di_Properties diProps = ADODataSet1->Properties;
_diProperty diProp1;
_diProperty diProp2;
diProps->Get_Item(varURProp, diProp1);
diProps->Get_Item(varUTProp, diProp2);
diProp1->Set_Value(adResyncAll);
diProp2->Set_Value(varTABLE);
In general, to access a property represented by a DelphiInterface, use the
Get_xxx method that takes a DelphiInterface reference as a parameter.
Mark Guerrieri
mguerrieri@cmsgrp.com
"Daryl" <daryl.stock@qr.com.au> wrote in message
news:3de5bba6$1@newsgroups.borland.com...
> Hi
> I recently posted a linker error message for comment (see below). The
> problem only started when I tried to convert a BB5 application using ADO
to
> Builder 6. I have now discovered the problem the offending code is shown
> below for comment. If I comment out the lines there is no problem...
>
> Can anyone please help identify what the problem is.
>
> Thanks
> Daryl
>
> ADODataSet1->Properties->_scw_Get_Item(varURProp)->Value = adResyncAll;
> ADODataSet1->Properties->_scw_Get_Item(varUTProp)->Value = varTABLE;
>
> The linker error is:
> Unresolved external 'SYSTEM::__linkproc ___ fastcall CheckAuto()'
referenced
> from E:\PROGRAM FILES\BORLAND\CBUILDER6\LIB\RELEASE\VCLE.LIB | syssupp
>
>
file://---------------------------------------------------------------------
> ------
> void TForm1::setADOProperties()
> {
> OleVariant varURProp = OleVariant(String("Update Resync"));
> OleVariant varUTProp = OleVariant(String("Unique Table"));
> OleVariant varTABLE = OleVariant(String("tblTransaction"));
> enum CEResyncEnum {adResyncNone, adResyncAutoIncrement,
adResyncConflicts,
> adResyncUpdates=4, adResyncInserts=8,
adResyncAll=15};
>
> // Set ADORecordset dynamic parameters
> ADODataSet1->Properties->_scw_Get_Item(varURProp)->Value = adResyncAll;
> ADODataSet1->Properties->_scw_Get_Item(varUTProp)->Value = varTABLE;
> }
>
file://---------------------------------------------------------------------
> ------
>
>
>
>
Technical Details
Message-ID:
<3dec4a87$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mailReferences:
<3de5bba6$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,bbcb96c0c37c78a9,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-12-02 22:15:46 PST From: "Mark Guerrieri" <markg11@comcast.net> Newsgroups: borland.public.cppbuilder.database.ado References: <3de5bba6$1@newsgroups.borland.com> Subject: Re: BCB6 Issue - Setting an ADO recordsets properties Date: Tue, 3 Dec 2002 01:09:12 -0500 Lines: 69 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 68.44.67.205 Message-ID: <3dec4a87$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1038895751 68.44.67.205 (2 Dec 2002 22:09:11 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail