🚀 go-pugleaf

Another possibility is that I can perform whatever updates on the client
data set while it is "in place". Is it possible to sort a record set while
it is in place, or prior to applying any changes?


"mpowell" <mike.powell@transcore.com> wrote in message
news:3acb80f0_2@dnews...
>
> 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.
> >
> >
> >
>
>