Solved

MDX

Posted on 1998-07-10
10
498 Views
Last Modified: 2010-04-04
What is MDX file ?

Is it the index file for the Paradox table ? If no, is there similar file for Paradox table ? If yes, how and when will it be created ?

Andrew
0
Comment
Question by:andrewyu
  • 5
  • 3
  • 2
10 Comments
 
LVL 3

Accepted Solution

by:
Matvey earned 50 total points
ID: 1357575
As far as I remember it is an index file for XBASE (dBase). Like all index files it should be created when the user of the table creates indexes for the table.

If you want to know about it's format, goto www.wotsit.org and enter MDX in the search box.

http://loki.borland.com/winbin/bds.exe?getdoc+2821+Delphi
describes DBF and MDX.

http://www.e-bachmann.dk/docs/xbase.htm
another link to this file description.

http://www.wotsit.org/wdatabas/dbase.zip
http://www.wotsit.org/wdatabas/dbf.zip
Downloadable text.

Regards, bosism@netvision.net.il
0
 

Author Comment

by:andrewyu
ID: 1357576
So, is it related to Paradox !

Andrew

0
 
LVL 3

Expert Comment

by:Matvey
ID: 1357577
I'm afraid not, but maybe some paradox engines create files with the same extention for it's indexes. Anyway, the only info I found about this was related to XBASE and not Paradox. I advice you to see the seccond link (http://www.e-bachmann.dk/docs/xbase.htm).

Regards, Matvey
0
 

Author Comment

by:andrewyu
ID: 1357578
So, what is the file extension for index file of Paradox table ?
0
 
LVL 5

Expert Comment

by:mayhew
ID: 1357579
Paradox and DBASE handle indexes differently.  In DBASE you can have several indexes and they are referenced in an mdx.  

In Paradox, you have a key which is your primary index that's kept in a .px file.  Then you can create secondary indexes.  For each secondary index you create, Paradox will generate a .xg? and .yg? file where the ? is a number that apparently indicates the order in which the indexes were created.

For example, if I create a Paradox table named TEST with a primary index and two secondary indexes, I will have the following files:
TEST.DB
TEST.PX
TEST.XG0
TEST.YG0
TEST.XG1
TEST.YG1

Hope this is helpful.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:andrewyu
ID: 1357580
So, you meant that test.XG0 and test.YG0 is the files for the same secondary index ?
0
 
LVL 5

Expert Comment

by:mayhew
ID: 1357581
That is my understanding, yes.

I created two tables (one in Paradox 7 and one in Paradox 4 for comparison's sake) and kept creating and deleting secondary indexes.  

For every index I created, an XG? and YG? were created.  When I deleted an index, both the xg and yg disappeared.
0
 

Author Comment

by:andrewyu
ID: 1357582
Thank you very much !

But, when and how do I use the property IndexFiles in TTable ?
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1357583
A dBASE MDX file can contain several indexes. You specify the IndexFiles property (used only for dBASE) to define the list of available index files, that will be opened and updated later if needed.
After a list of available index files is set, you can specify the IndexName property to set the current index that will determine the sorting and searching for your table.

IndexFiles can be also left blank, I think, if there is just one index file for the table. That file will be used by default and the IndexName combo-box will show indexes available from the file. (table name "MyTable.DBF" - index "MyTable.MDX)
0
 

Author Comment

by:andrewyu
ID: 1357584
Thank you very much !
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi XE10, DigitalPersona Fingerprint reader and MySQL 6 216
Delphi TcxGrid group footer summary 3 208
Delphi : could not find program, '...exe' 2 147
Base1 Encode/Decode 3 67
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now