How to check ADI Yes/No Exist index TAG name?

Taiwan · Post by **Taiwan** » Tue Sep 05, 2006 9:09 am

Hello

I use AIS to connect ADT/ADI database/index for remote access.
Now, I want to make reindex my ADI like CDX.
So I need to delete ADI file or delete TAG name.
How to know or get this ADI Tag name function or delete Tag name?
Anyone have good solution or idea for this?

Thank you

Regards,

Richard

R.F. · Post by **R.F.** » Tue Sep 05, 2006 4:19 pm

You should not need to perform any reindexing task, I mean, you don't need to reindex any table since ADS indexes should not cause any problem at all.

Anyway, if you want to "reindex", do the following:

Close all opened tables.
Manually erase all the ADI files (FERASE("file.adi")
Perform the index as usual
you are done.

Try to avoid the reindexing, I repeat, you don't need to reindex since you are working with ADS.

Badara Thiam · Post by **Badara Thiam** » Thu Sep 07, 2006 10:21 am

RF wrote:Try to avoid the reindexing, I repeat, you don't need to reindex since you are working with ADS.

Without ADS also, if you open each index before every time you
upgrade yours databases.

Regards,

Taiwan · Post by **Taiwan** » Thu Sep 07, 2006 10:22 pm

Hello All,

Thanks for your idea and suggestion.

I will try it.

Regards,

Richard

Brian Hays · Post by **Brian Hays** » Mon Sep 11, 2006 6:10 am

But to answer the specific question:
All the standard ord* rdd functions should work: ordDestroy, ordName, etc., as well as their commands like DELETE TAG. Also:
dbOrderInfo(DBOI_ORDERCOUNT, cBag), etc.

Still, I also think it's best to delete the adi file.
And the other comment on the forum re not needing to reindex as long as you open indexes before updates I feel is wrong. Rene's point is that IF you are using a data server (SET SERVER REMOTE) you don't need to reindex. ANY shared file rdd (including ADS with the LOCAL server) IS unavoidably subject to index corruption no matter how careful your code is.

R.F. · Post by **R.F.** » Mon Sep 11, 2006 3:40 pm

Reading carefully I noticed that you are using the AIS, so things may change:

If you are using AIS you are using ADS Remote Server, so you don't need to perform any reindex operation at all.

Reindexing erasing the ADI files is only possible when you are working in a LAN, because the AIS doesn't have direct access to the files in the remote server.

And Bryan says, if you are using the local server, you are still in danger of index corruption

Marcelo Via Giglio · Post by **Marcelo Via Giglio** » Mon Sep 11, 2006 7:20 pm

Hello,

you can try with ADSREINDEX() (read the manual)

regards

Marcelo

Brian Hays · Post by **Brian Hays** » Mon Sep 11, 2006 8:47 pm

Generally speaking, I strongly recommend staying with the clipper-compatible standard commands and functions. In the early days of rddads there was a need to create some wrapper functions to directly access ads stuff, but now almost all functionality (except where an ads feature is beyond what the common rdds offer) is integrated into the core rdd and routed correctly to ads.

It keeps your code cleaner and makes it less ads-specific.

It is ALWAYS a good idea to review the ADS help file to understand the underlying functions and features.