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

Tags:

×271
×133
×20

Asked: 03 Nov '14, 10:49

Seen: 1,414 times

Last updated: 03 Nov '14, 10:49

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.