I'm creating an application to check the indexes from some tables using the sp_helpindex.
My problem is that if no index are found I got an empty result set.
(The result I get running the Query analyzer is only the text:
"The object does not have any indexes.")
And I get the exeption " commandtext does not return a resultset.
How get I get around this?
qry2.SQL.Text:= 'sp_helpindex ' + QuotedStr(MyTable.TableOwner + '.' + MyTable.TableName);
while not qry2.Eof do