FiveTech Support Forums

Hi,

As my subject, should I change my databases to CDX Index?

If yes, Is there any easy method to convert my programs?

I suppose that xBrowse recognize the indexes to change sort order in CDX. Is it true?

Thanks,

Hello,

To use CDX instead of NTX, is the better option.

If you open a database, the CDX-Index is opend as well.

I use ORDCREATE and ORDCONDSET

Sample 1 :

Old Style :

Index on upper(archiv_no) + DESCEND(str(n_year) + str(n_month)) to "FAKT1" UNIQUE

New Style :
( .T. included in the Index-array means UNIQUE )

ORDCREATE( ,"FAKT1","LOWER(archiv_no) + DESCEND(str(n_year) + STR(n_month)", ;
{|| LOWER(archiv_no) + DESCEND(str(n_year) + STR(n_month) } , .T. )

-----------------------------------------------------------

Sample 2 :
// Index-direction Down = .T.

Old Style

Index on DESCEND(str(n_year) + invoice_no + archiv_nr) ;
to "FAKT3" UNIQUE

New Style

ORDCONDSET( , , , , , , , , , , .T. ) // DESCEND
ORDCREATE( ,"FAKT3","STR(n_year) + invoice_no + archiv_no", ;
{|| STR(n_year) + invoice_no + archiv_no } , .T. ) // UNIQUE

Be careful, to use soemething like : UPPER(Name)
In case of < ÖÄÜ > at the beginning of the name, it doesn' work.
You have to use LOWER !!!!

Regards
Uwe

Hakan,

> I suppose that xBrowse recognize the indexes to change sort order in CDX. Is it true?

Yes, XBrowse fully supports CDXs indexes.

Hello,

There is still another reason why CDX is better than NTX.

For each NTX-index of a file, a filehandle is opened.

If you have a file with 5 NTX-indexes, you have 6 filehandles opened.

In case of CDX, only one filehandle is opened of all the indexes.

So, CDX reduces the number of filehandles needed.

I have an application with 41 DBF-files of which 39 do have a CDX-file. This means 80 filehandles per user. All the CDX-files contain 660 indexes. One of my customers have 30 users. That means 2400 filehandles opened on the server. In case I had used NTX, that would mean more than 21000 filehandles.

Thank you for informations.

How Can I migrate to CDX. Is there anything to be careful?

Is Clipper 5.2e support CDX?

Thanks,

Is Clipper 5.2e support CDX?

Hi Fafi,

I use Clipper 5.2e and Blinker 5.1 for my old programs. I have compiled my old programs with xHarbour and FWH using preprocessors. So I use the same source. I just want to know that can i use CDX in Clipper 5.2e. There are DBFCDX.LIB in my Clippers LIB directory. I thought I can use it.

Thanks,

I used sixcdx.lib and machsix.lib

Regards
Fafi

Horizon wrote:Hi Fafi,

I use Clipper 5.2e and Blinker 5.1 for my old programs. I have compiled my old programs with xHarbour and FWH using preprocessors. So I use the same source. I just want to know that can i use CDX in Clipper 5.2e. There are DBFCDX.LIB in my Clippers LIB directory. I thought I can use it.

Thanks,

Hi Enrico !

Can I get it ?

Regards
Fafi

fafi wrote:Hi Enrico !

Can I get it ?

Regards
Fafi

Hello Enrico,

as far as i know, the comix-rdd has been included
in the last Clipper-version 5.3b ( no extra product ).

Regards
Uwe

ukoenig wrote:Hello Enrico,

as far as i know, the comix-rdd has been included
in the last Clipper-version 5.3b ( no extra product ).

Regards
Uwe

Hello, Enrico
The Link :

http://www.grafxsoft.com/2comix.htm

Regards
Uwe

ukoenig wrote:Hello, Enrico
The Link :

http://www.grafxsoft.com/2comix.htm

Regards
Uwe