Erro on query: No analysis opened: <MyDS1> file not described.

Hello everyone, hope to find some answer on this question as it is driving me crazy.

I want to search on a database all indexes of tables that have certain name. The query is:

create table aux_table (
idx_name char(20),
idx_desc char(100),
idx_keys char(50))
insert into aux_table EXEC sp_helpindex 'CRWMEMBR'
select IDX_NAME,idx_desc,idx_keys from aux_table
drop table aux_table

But when executing I receive the error attached at the end.
The code I'm running is:

IF NOT HExecuteSQLQuery(MyDS1,Connexion_Name,hQueryWithoutCorrection, MyQry1) THEN
   Info("[Error reading indexes]:"+CRLF+MyQry1,HErrorInfo())
ELSE
  HReadFirst(MyDS1)
  WHILE NOT HOut(MyDS1)
//    ...do something...
    HReadNext(MyDS1)
  END
END

HReadFirst function called.
No analysis opened: <MyDS1> file not described.

Technical Information

Project : SkySQL

Dump error of module <WD110HF.DLL> <11.00Hah>.

- WL Call:
Processing <Main.Button1>, line <17>, thread <0>
Function <HReadFirst>, syntax # <3>

- Level: fatal error (EL_FATAL)

- Error Code: 70018

- WD55 Error Code: 18

- No system error code

- No system error message

- What happened?
No analysis opened: <MyDS1> file not described.

- Debug Information:
iehf=32012
Fonction (7,10)

- Attached Information:
EIT_LOGICALTABLENAME : <MyDS1>
EIT_DATEHEURE : 12/03/2009 14:03:40
EIT_PILEWL :
Click Button1 (Main.Button1), ligne 17

- Identifier in .err: 70114


Help

- If the file is described inside an analysis, check that this analysis
is associated with the project (the analysis will be automatically opened).
or that the analysis is opened with HOpenAnalysis.
- If the file do not come from an analysis, check that it has been declared
with one of the following functions:
HDeclare, HDeclareExternal or HDescriveFile.


Message forwarded from pcsoft.us.windev

Hmmm...some light on the darkness...If i create fisically the aux_table with the 3 correspondient columns I dont thet the error. Seems that creating the table dinamically and inserting the values with the EXEC sp_helpindex procedure is the problem.... but the problem is that the job hs to be done without fisically accessing the database. I mean, from a remote computer with an application that reads on it....any clue? thanks...

Message forwarded from pcsoft.us.windev

Problem solved...the problem was that some of the tables does not have any index and the sql result was nor a table or error but just a plain text:
OBJECT XXXX DOES NOT HAVE AN INDEX OR THE USER DOES NOT HAVE AUTHORIZATION.

My way of solving the problem? Use EXCEPTION with the HReadFirst, if there are indexes then do the thing if not then continue with next table... easy but it took me half day to find the anser...thanks all!

Message forwarded from pcsoft.us.windev