AdsGetIndexHandleByOrder without counting FTS indexes

0

Hi,

As per help file AdsGetNumIndexes does not return information for full text search indexes. Using AdsGetIndexHandleByOrder as in the Delphi example below, when some FTS indexes were created before the some of the other indexes, the last indexes will not be returned.

I actually encountered this as a Bug in xHarbour with dbOrderInfo(DBOI_NAME,, nIndexNum) not returning the proper info when using a for loop on 1 to ordCount().

What is the correct method to do this.

Thanks

procedure TForm3.Button1Click(Sender: TObject);
var
  hIndex: ADSHANDLE;
  I: Integer;
begin
  if not AdsTable1.Active then
    AdsTable1.Open;
  Memo1.Lines.Clear;
  for I := 1 to AdsTable1.AdsGetNumIndexes do
  begin
    hIndex := AdsTable1.AdsGetIndexHandleByOrder(I);
    Memo1.Lines.Add(AdsTable1.AdsGetIndexName(hIndex));
  end;
end;

asked 03 Nov '14, 10:49

Jack's gravatar image

Jack
545●33●36●54
accept rate: 14%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Tags:

×271
×133
×20

Asked: 03 Nov '14, 10:49

Seen: 1,406 times

Last updated: 03 Nov '14, 10:49

Related questions

ADS on Windows Server with XHarbour

Ads.ini file with harbour

Error 7008 starting a transaction

Visual Foxpro vs Delphi connecting to ADS

Why deleting and inserting new records does not remain ordered ?

Result of Store Procedure sp_mgGetTableIndexes ?

Installing ADS for different Delphi versions

6420 Windows 7 Clients after update to 11.10.0.10

Query locks table

Table sort on index.

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.