Search found 28 matches: ntxs

Return to advanced search

Re: create a function with Tdatabase

... Maybe you didn't know that CDXs have always had the option to open all the indexes automatically when the DBF is opened. And as I understand it, NTXs can now do that also. REQUEST DBFCDX rddsetdefault( "DBFCDX" ) SET EXCLUSIVE OFF SET(_SET_AUTOPEN, .T. ) yes I knew it but it happens ...
by Silvio.Falconi
Thu Apr 29, 2021 8:01 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: create a function with Tdatabase
Replies: 7
Views: 1172

Re: create a function with Tdatabase

Sivio,

Maybe you didn't know that CDXs have always had the option to open all the indexes automatically when the DBF is opened. And as I understand it, NTXs can now do that also.

REQUEST DBFCDX
rddsetdefault( "DBFCDX" )
SET EXCLUSIVE OFF
SET(_SET_AUTOPEN, .T. )
by James Bott
Wed Apr 28, 2021 5:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: create a function with Tdatabase
Replies: 7
Views: 1172

Re: Problems with FWH 1805 BUILD 1 accessing files DBF

James Bott wrote:There are reasons why CDXs are better than NTXs such as CDXs are smaller, faster, all indexes for a dbf can be placed in the same file, and you can use scopes.


Scopes can be also used with DBFNTX.

EMG
by Enrico Maria Giordano
Sat Oct 06, 2018 8:21 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problems with FWH 1805 BUILD 1 accessing files DBF
Replies: 15
Views: 2989

Re: Problems with FWH 1805 BUILD 1 accessing files DBF

There are reasons why CDXs are better than NTXs such as CDXs are smaller, faster, all indexes for a dbf can be placed in the same file, and you can use scopes. If you are interested in any of those features then it is worth upgrading.

Once I tried CDXs, I never used NTXs again.
by James Bott
Sat Oct 06, 2018 12:33 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problems with FWH 1805 BUILD 1 accessing files DBF
Replies: 15
Views: 2989

Re: SQL - advice

... ADS rdd on your main .prg 2. Make ADSRDD the default RDD 3. Re-index your tables with ADSCDX or ADSNTX in case you are still using ntxs. 4. Use only ADSCDX to work with your tables. Phase #2: 1. Create an ADS Datadictionay and bind all your tables to the DD. 2. Have the user log ...
by reinaldocrespo
Tue Mar 10, 2015 12:44 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: SQL - advice
Replies: 9
Views: 2355

Re: Network Issue

... CDX indexes. Filters ARE ALWAYS slow. Use SCOPES and INDEX. With an INDEX you can do incremental searches. Index size on CDX are way smaller than NTXs. Why ? By default they compact / compress repeating key values. For example: if you have an index key based on DTOS(dDateField) and have 1000 records ...
by HunterEC
Thu Jan 16, 2014 4:46 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Network Issue
Replies: 36
Views: 10921

Re: Scoped xbrowse

Hunter, The older TWBrowse had crude scope settings built-in, but that was done probably before NTXs had scoping (probably when most of us were still using Clipper). Most everyone is using CDXs now, but even NTXs have scopes under (x)Harbour so there is no need for scoping ...
by nageswaragunupudi
Fri Sep 13, 2013 3:23 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Scoped xbrowse
Replies: 8
Views: 1349

Re: Scoped xbrowse

Hunter, The older TWBrowse had crude scope settings built-in, but that was done probably before NTXs had scoping (probably when most of us were still using Clipper). Most everyone is using CDXs now, but even NTXs have scopes under (x)Harbour so there is no need for scoping ...
by James Bott
Fri Sep 13, 2013 12:16 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Scoped xbrowse
Replies: 8
Views: 1349

Re: ADS NOT SUPPORT DECRYPT AND ENCRYPT FROM FIVEWIN

... so that all Clipper dbf operation would be carried out by the server. These were Clipper and c programmers writing mobile code. Their .dbfs and ntxs used get corrupted all the time, so they decided to do something about it. That's how ADS was born. An SQL company called iAnywhere got interested ...
by reinaldocrespo
Fri Oct 12, 2012 6:21 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADS NOT SUPPORT DECRYPT AND ENCRYPT FROM FIVEWIN
Replies: 15
Views: 4195

Re: ADS : DbSetFilter VS SQL Statement?

... True, you may execute SQL without a DD connection and still take advantage of indexes, but that's only true with compound indexes (cdx, adi). NTXs will not be used by the SQL engine since there is no way for the sql parser to be aware of those indexes. However, provided that you do have a ...
by reinaldocrespo
Wed May 30, 2012 1:26 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADS : DbSetFilter VS SQL Statement?
Replies: 6
Views: 3019

Re: cmxAutoOpen

It appears that you have not opened the indexes. Also, the error message shows that you are using NTXs not CDXs. Again I am not sure that your old version of FWH supports CDXs. When having problems like this I try to write the smallest possible code to test the problem. ...
by James Bott
Wed Jan 26, 2011 4:07 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: cmxAutoOpen[solved]
Replies: 19
Views: 4589

Re: FWPPC and HP IPAQ 114

Simon,

Te refieres al DBF ó al fichero índice ?

Estas trabajando con CDXs ó con NTXs ?
by Antonio Linares
Fri Sep 10, 2010 10:55 pm
 
Forum: FiveWin para Pocket PC
Topic: FWPPC and HP IPAQ 114
Replies: 33
Views: 11147

Re: I'm looking for some advice/suggestions.

... then I suppose it would be better to set an optimized filter (AOF -Advantage optimized filter) based on an index (CDX or ADI work better than NTXs). Here is a link that explains how to use an AOF: http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_concepts/advantage_functionality/advantage_optimized_filters.htm ...
by reinaldocrespo
Fri Jan 15, 2010 12:29 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: I'm looking for some advice/suggestions.
Replies: 6
Views: 1168

Re: Amigos del Foro

... muchos años. Haciendo incapié en lo raro del comportamiento, si te fijas nunca usé el Dtos() en la busqueda DBSEEK(FI,.T. ) y siempre funcionó con NTXs, no así con CDXs. Parece que con CDX me falla solamente cuando el indice lo compone UN SOLO CAMPO y este es tipo Date, ya que los demas indices ...
by FranciscoA
Sat May 23, 2009 10:12 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Amigos del Foro
Replies: 3
Views: 902

Jack,

There is nothing wrong :-)

NTX files can have empty spaces in their internal nodes. So different RDDs versions can modify the way the NTXs are created, and then you get different NTXs sizes.

What you have to check is that the indexes are working fine. Thats what really matter :-)
by Antonio Linares
Thu Dec 11, 2008 8:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Size of a NTX File
Replies: 5
Views: 1127
Next

Return to advanced search