Hi:
Thanks Carol. I'm working in that line..
Best,
Alberto
>Seems like you could use SPT to access the stored procedure Sergey mentioned via SQLExec:
>
>From the help:
>You can use Visual FoxPro SQL pass-through technology to create and execute stored procedures on a remote server. Stored procedures can greatly enhance the power, efficiency, and flexibility of SQL, and dramatically improve the performance of SQL statements and batches. Many servers provide stored procedures for defining and manipulating server database objects and for performing server system and user administration.
>
>Note: The examples in this section use Microsoft SQL Server syntax unless otherwise noted.
>To call a server stored procedure
>
>Use the SQLEXEC( ) function with the stored procedure name.
>For example, the following code displays the results of calling a stored procedure named sp_who on SQL Server using an active connection to the data source sqlremote:
>
>From me - So you would do something like:
>
>nConnectionHandle = SQLCONNECT('sqlremote')
>lnsuccess = SQLEXEC(nConnectionHandle, 'sp_helpindex')
>
>
>That ought to get you a cursor of information about the indexes available for the SQL database you are accessing.
>
>>Hi:
>>
>>There is any instruction in Fox to know the index in a SQL table.
>>
>>With sqlColumns() you know the table fields, but the index?
>>
>>Best,
>>
>>Alberto Rodriguez