Recordset Property syntax

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

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by Tony Mon, 12 Feb 2001 13:51

#5779

Author: Tony
Date: Mon, 12 Feb 2001 13:51

3 lines
951 bytes

Can someone show me the cppbuilder syntax for setting/getting ado recordset
properties? For example:
Rs->Properties("Update Resync")->Value = adResyncUpdates.

Re: Recordset Property syntax

#5780

Author: Eric
Date: Mon, 12 Feb 2001 14:45

10 lines
1059 bytes

If you find out please let me know.  I've asked twice on this board
and still don't know how.

On Mon, 12 Feb 2001 08:51:09 -0500, "Tony" <hse@hill-soft.com> wrote:

>Can someone show me the cppbuilder syntax for setting/getting ado recordset
>properties? For example:
>Rs->Properties("Update Resync")->Value = adResyncUpdates.
>
>

Re: Recordset Property syntax

#5781

Author: Giuliano
Date: Mon, 12 Feb 2001 14:45

19 lines
1439 bytes

On Mon, 12 Feb 2001 08:51:09 -0500, "Tony" <hse@hill-soft.com> wrote:

>Can someone show me the cppbuilder syntax for setting/getting ado recordset
>properties? For example:
>Rs->Properties("Update Resync")->Value = adResyncUpdates.
>

Hi Tony,

    try with something like this (untested):

    _di_Properties Properties( ADODataSet->Recordset->Properties );
    for( int Idx = 0 ; Idx < Properties->Count ; Idx++ )
        if( Properties->Item[Idx]->Name == WideString( "Update Resync" ) )
            Properties->Item[Idx]->Value = adResyncUpdates;

Ciao

Giuliano

Re: Recordset Property syntax

#5782

Author: Tony
Date: Mon, 12 Feb 2001 17:09

40 lines
2223 bytes

Hi Giuliano,

After playing around with your example I was able to come up with following
that eliminates the need for the loop to find the specific property. The
_di_Properties declaration is the key. Thank you!!!

    _di_Properties Properties(( ADODataSet->Recordset->Properties );

    int V = Properties->Item[WideString("Update Resync")]->Value;  //
original value

    Properties->Item[WideString("Update Resync")]->Value =
adResyncAutoIncrement + adResyncUpdates;

    V = Properties->Item[WideString("Update Resync")]->Value;    // new
value

Giuliano <gcardinali@remove.adhoc.net> wrote in message
news:3a87f4b7.319479567@newsgroups.borland.com...
> On Mon, 12 Feb 2001 08:51:09 -0500, "Tony" <hse@hill-soft.com> wrote:
>
> >Can someone show me the cppbuilder syntax for setting/getting ado
recordset
> >properties? For example:
> >Rs->Properties("Update Resync")->Value = adResyncUpdates.
> >
>
> Hi Tony,
>
>     try with something like this (untested):
>
>     _di_Properties Properties( ADODataSet->Recordset->Properties );
>
>     for( int Idx = 0 ; Idx < Properties->Count ; Idx++ )
>         if( Properties->Item[Idx]->Name == WideString( "Update Resync" ) )
>             Properties->Item[Idx]->Value = adResyncUpdates;
>
> Ciao
>
> Giuliano

Re: Recordset Property syntax

#5784

Author: Giuliano
Date: Mon, 12 Feb 2001 19:09

12 lines
1225 bytes

On Mon, 12 Feb 2001 12:09:07 -0500, "Tony" <hse@hill-soft.com> wrote:

>Hi Giuliano,
>
>After playing around with your example I was able to come up with following
>that eliminates the need for the loop to find the specific property. The

Great! :-)

Ciao!

Giuliano

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads