FiveTech Software tech support forums

... is a mess right now since it was originally written for testing filters vs scopes. However, it is very simple, open the database with indexes (CDXs). Set the current index. Set the scope, then call browse(). It should happen instantly. I don't think that DBF speed is your issue. Switching to ...

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 ...

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. )

... The variable oCustomers should be declared as LOCAL. Note that you can still pass oCustomers to a function if you wish. One last thing, I am using CDXs that auto-open when the database is opened thus you don't need to deal with them. I also always have the primary key index as the first index so ...

... You could not create a function that would give me the return of the archive and the loading of the its indexes in an array aIdx? If you are using CDXs they are all opened automatically. And if you are using objects the database and indexes are opened automatically even if they aren’t CDXs. >On ...

Nages,

We can understand from his code that he is using DBFNTX.

Thanks, I missed that. Maybe it is a good time to switch to CDXs.

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

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.

Success at last! --------------- Everyone, The DBFs and CDXs are all supposed to be in the current directory. And they are on my computer but not on the work computer. With both settings "set to show hidden files" and "show hidden system ...

Otto,

I have not yet tried Total Commander. I am using Win 10 File Explorer.

Here are which indexes are visible and invisible:

Visible CDSs:
Document.cdx
Work.cdx

Invisible CDXs:
Project.cdx
Type.cdx
Group.cdx

Just an update. Turning off "Hide protected operating and system files" didn't make any difference. Still only 2 of the 5 CDXs are visible. I tried rebooting after changing the setting and that didn't work either.

At least the program is seeing them...

Tim, Thanks for the input. It just occurred to me, that I can add a check for the needed CDXs into the program. Actually, I already had: if ! file(work.cdx) …(reindex) endif For each CDX, but when I looked at the directory not all of them were there. That is what started ...

... for several years now. Still I am anxious to see if changing that setting fixes it on the other computer. Not sure why it would apply to some CDXs but not all CDXs. James

... Most web development languages are only SQL. What I'm trying to say is that you will probably have to learn some SQL in order to access your dbfs/cdxs across the web using PHP with Advantage but that limitation is imposed by the web developing language and not Advantage. Advantage speaks both ...

... Most web development languages are only SQL. What I'm trying to say is that you will probably have to learn some SQL in order to access your dbfs/cdxs across the web using PHP with Advantage but that limitation is imposed by the web developing language and not Advantage. Advantage speaks both ...