Re: TClientDataSet RecNo

Article View: borland.public.cppbuilder.database.multi-tier

Article #606

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#606

From: mpowell
Date: Wed, 04 Apr 2001 20:10

36 lines
1788 bytes

Hello,

I'd really appreciate an answer to this. Is it possible to reorganize
(perhaps even swap) a record within a data set? The RecNo property isn't
quite what I had in mind, as it seems only to operate on the cursor. I would
like to move the record, not the cursor, within a data set.

Thanks.


"mpowell" <mike.powell@transcore.com> wrote in message
news:3ac4bbb2$1_1@dnews...
>
> I have a record set that I would like to reorder. Is the RecNo property
the
> property that will correctly do so? IOW, If I make any changes to RecNo
will
> the record numbers for the remaining records change accordingly.
>
> For example, say I have the following record set.
>
> NAME; ID; RECNO
> JOHN; 101; 1
> PAUL; 201; 2
> RINGO; 301; 3
>
> Say I change RINGO to RECNO=1. Does this then change JOHN to RECNO=2 and
> PAUL to RECNO=3? Alternately, what happens if I change PAUL to RECNO=3?
What
> precisely is the effect of changing RECNO in this manner?
>
> Thanks in advance.
>
>
>

Technical Details

Message-ID: <3acb80f0_2@dnews>

Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3ac4bbb2$1_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,d6af851d71f1333
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-04-04 13:58:18 PST
From: "mpowell" <mike.powell@transcore.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
References: <3ac4bbb2$1_1@dnews>
Subject: Re: TClientDataSet RecNo
Date: Wed, 4 Apr 2001 14:10:03 -0600
Lines: 38
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: 198.59.170.194
Message-ID: <3acb80f0_2@dnews>
X-Trace: dnews 986415344 198.59.170.194 (4 Apr 2001 13:15:44 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message