dbTalk Databases Forums  

Paradox indexes

comp.databases.paradox comp.databases.paradox


Discuss Paradox indexes in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fred Evans
 
Posts: n/a

Default Paradox indexes - 01-10-2008 , 12:14 PM






Can someone tell me how to find the indexes being used in a .db file??

many thanks



Reply With Quote
  #2  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM






For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #3  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #4  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #5  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #6  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #7  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #8  
Old   
Michelle
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:29 PM



For Windows versions of Paradox, right-click on the table. Choose Info
Structure. The field list will come up. Any fields with a picture of a key
next to them, are part of the Primary index. Click on the "Secondary Index"
tab which will list any secondary indexes.

For DOS version choose Tools - Info - Structure. Any fields with an
asterisk are part of the primary index. From main menu again, choose
Tools - Info - TableIndex. This will show any secondary indexes.

Michelle

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #9  
Old   
Steven Green
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:31 PM




identification?.. "table name" plus extension..

data file - .db
primary index - .px
indexes - .x* and .y* pairs

actually in use at this moment?.. that's not so easy.. what context? what
platform/program?


--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





Reply With Quote
  #10  
Old   
Steven Green
 
Posts: n/a

Default Re: Paradox indexes - 01-10-2008 , 12:31 PM




identification?.. "table name" plus extension..

data file - .db
primary index - .px
indexes - .x* and .y* pairs

actually in use at this moment?.. that's not so easy.. what context? what
platform/program?


--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Fred Evans" <fred (AT) polyflexseals (DOT) co.za> wrote

Quote:
Can someone tell me how to find the indexes being used in a .db file??

many thanks





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.