Hi,

How can I determine all indexes and their corresponding index expressions for a VFP table that is being accessed via SPT?

As an example, below is how I implemented the logic to obtain indexes for SQL Server and Oracle tables.

TIA

Fernando

* Parameters

 gSQLHandle  = Handle of the ODBC connection
 cTableName  = Table to obtain indexes
 cTableOwner = Owner of table

* Expression for a SQL Server Table

 cSelectStr = "Exec sp_helpindex ?cTableName"

* Expression for an Oracle Table

 cSelectStr = "Select Table_Name     ,                              " + ;
              "       Table_Owner    ,                              " + ;
              "       Index_Name     ,                              " + ;
              "       Column_Position,                              " + ;
              "       Column_Name    ,                              " + ;
              "       Descend                                       " + ;
              "                                                     " + ;
              "From   All_Ind_Columns                               " + ;
              "                                                     " + ;
              "Where  Trim (Lower (Table_Name )) = ?cTableName  and " + ;
              "       Trim (Lower (Table_Owner)) = ?cTableOwner     " + ;
              "                                                     " + ;
              "Order  By Index_Name, Column_Position                "

* Executes the SQL Command

 SQLexec (gSQLHandle, cSelectStr, "CurIndexes") 

* Logic to Build String with Index Expressions

. . .