🚀 go-pugleaf

Hi all,

I am using the following provider : MS OLE DB Provider for ODBC Drivers, to 
connect to InterBase.

I read in a previous posting that indexes are not supported in the provider 
for SQLServer.

This prompted me to find out if the above provider I used supports Indexes 
too. When I set the table to active in the code below, ADOTable_FPUser (a 
TADOTable) returns an exception - "Index does not exists". (See arrow 
pointer in the code below).

What I wanted to do was to search a table (using the Seek function) for a 
specific user ID (1234 in this example). I have double-checked that the 
table name and index name are correct (hopefully).

Code Snippet:
{
      ADOConnectionExternal->Connected = true;

      ADOTable_FPUser->Connection = ADOConnectionExternal;
      ADOTable_FPUser->TableDirect = true;
      ADOTable_FPUser->TableName = "FPUSER";
      ADOTable_FPUser->IndexName = "FPUSER_USERIDSTR";
      ADOTable_FPUser->CursorLocation = clUseServer;
      ADOTable_FPUser->Active = true; // <--- Error happens here.

      ADODataSet_FPUser->Seek("1234", soAfterEQ);
}

Does anyone have any idea? Or have I left out anything? Thank you.

Regards,
Tze Wan