dbTalk Databases Forums  

SwitchIndex on a Table Frame

comp.databases.paradox comp.databases.paradox


Discuss SwitchIndex on a Table Frame in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bill McCray
 
Posts: n/a

Default SwitchIndex on a Table Frame - 01-27-2008 , 07:42 PM






I needed some help. With Paradox, I mean. People think I need lots
of help in other ways, too, but I won't bother you with that.

Let's see: Paradox 9.00.738; Windows 2000.

On a form, I have three tableframes. Table B is a detail table for
Table A, and C is detail for B. In their Open Methods, Table A is set
to Edit and Tables B and C are set to Edit and a SwitchIndex is
performed. Table B is displayed in the secondary-index order, but
Table C is displayed in primary-index order. I haven't been able to
figure out why Table C ignores the SwitchIndex on it.

I have copied the form and am making a few changes in it. In this
version of the form, both Tables B and C ignore the SwitchIndex and
are displayed in primary-index order.

Anyone have suggestions on how I can get my tableframes to display in
secondary-index order?

Bill, the confused

----------------------------------------------------------------
Reverse parts of the user name and ISP name for my e-address

Reply With Quote
  #2  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM







If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #3  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #4  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #5  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #6  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #7  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #8  
Old   
Tony McGuire
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-27-2008 , 08:13 PM




If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?


--
------------------------------
Tony McGuire



Reply With Quote
  #9  
Old   
Dennis Santoro
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-28-2008 , 08:13 AM



If not you are going to need to show us the code. Basicaly you need to
call the object name for the table UIO with a switchindex and the index
name (or no index to go to the primary)

If not YourObject.swithcindex("yourindex") then
errorshow()
endif

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982


Tony McGuire wrote:
Quote:
If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?



Reply With Quote
  #10  
Old   
Dennis Santoro
 
Posts: n/a

Default Re: SwitchIndex on a Table Frame - 01-28-2008 , 08:13 AM



If not you are going to need to show us the code. Basicaly you need to
call the object name for the table UIO with a switchindex and the index
name (or no index to go to the primary)

If not YourObject.swithcindex("yourindex") then
errorshow()
endif

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982


Tony McGuire wrote:
Quote:
If a table is linked in a DM on one index, you can't swithindex to
another.

Is that the situation?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.