Very Computer

I'm trying to sort records in table frame "tableFrame" by secondary
index "PageName."  The following, placed on a pushButton, doesn't work:

     var
        ui UIObject
     endVar

     ui.attach(tableFrame)
     ui.switchIndex("PageName")

The following also does not work:

     var
        tc tcursor
     endVar

     tc.attach(tableFrame)
     tc.switchIndex("PageName")
     tableFrame.resync(tc)

I would expect either of these to work, but in both cases the scripts
run to completion (even when I have "Compile with debug" and place
each statement within an "If not. . .then errorShow() endIf").  The
tcursor is attaching properly, but at the end of the program the
tableFrame is still sorted by its primary index.

Any ideas?

Joe Herl
--

School of Music                              I am not called to be successful;
University of Illinois                          I am called to be faithful.
Urbana, Illinois 61801 USA                                   -- Mother Theresa

Hope this helps
Bob Barrows

Try opening the Tcursor on the table (.DB) itself, instaed  of attaching
it to the UIobject tableframe. Use the index you want in the open command,
and then your resync should work.
Scott

:
: >I'm trying to sort records in table frame "tableFrame" by secondary
: >index "PageName."  The following, placed on a pushButton, doesn't work:
:
: If the tableframe is bound to a detail table (i.e., a table linked to
: a master table in the data model), you won't be able to get it to use
: a secondary index.. The data model constrains it to the primary index.

Not true. You can specify any index you want in the data model.  The
default is the primary index, but if you click on the detail table, and
then click on the Link button, it brings up a dialog box that lets you
choose the index of the detail table.

If you always want the detail table sorted on the secondary index, that's
the way to go.  If you want to change the order by pushing a button, that
won't work.  I could never figure out how to do that. I could change the
order for the current master, but it always reverted to the default order
when I moved to a new master.

--

ISG Technologies Inc.   6509 Airport Rd., Mississauga  Ont.  Canada   L4V 1S7

Bob

Quote:>>> The data model constrains it to the primary index.
>>Not true. You can specify any index you want in the data model.  The
>>default is the primary index, but if you click on the detail table, and
>>then click on the Link button, it brings up a dialog box that lets you
>>choose the index of the detail table.
>Right, I should have said "The data model constrains it to the index
>chosen when defining the link"
>Thanks for the catch.

Joe
--

School of Music                              I am not called to be successful;
University of Illinois                          I am called to be faithful.
Urbana, Illinois 61801 USA                                   -- Mother Theresa

Hope this helps
Bob Barrows

: >>> The data model constrains it to the primary index.
:
: >>Not true. You can specify any index you want in the data model.  The
: >>default is the primary index, but if you click on the detail table, and
: >>then click on the Link button, it brings up a dialog box that lets you
: >>choose the index of the detail table.
:
: >Right, I should have said "The data model constrains it to the index
: >chosen when defining the link"
: >Thanks for the catch.
:
: Okay, I've tried this, but when I change to a secondary index and click
: on OK the link is broken.  Don't the linked fields have to be the same
: in both tables for the link to work?

Define your secondary index with the link field as the first sort field,
followed by whatever other fields you want to sort on.

Having said that, as I recall from your second posting, you are trying
to sort your second table by a field in the third table.  I don't know
how that would work (but then I haven't looked at it in detail, so there
may be a way to do so).

--

ISG Technologies Inc.   6509 Airport Rd., Mississauga  Ont.  Canada   L4V 1S7