Hi, Nancy!

>
>I see. I didn't read your message carefully. Sorry about that.

Hey, no need to apologize yourself. :-)


>I'm not using Steve's utility anymore, so I'm not familiar with his code in >the CreateIndices method. Have you stepped through it? What is the error? Is >the problem that the method assumes that the table is not indexed (rather than >assuming indices might be missing)?

I deliberately deleted a cdx file from my HD (movprod.cdx). This is a situation in which I already passed with an user (yes, they deletes CDX files, and sometimes even DBC files :-( )

Then, I need to regenerate this file.

Well, here goes some lines of code generated by GenDBCX:

CASE tnPassNumber = 3
IF !USED('MOVPROD')
USE MOVPROD AGAIN IN 0 ALIAS MOVPROD
ENDIF
SELECT MOVPROD
***** Create each index for MOVPROD *****
SET COLLATE TO 'GENERAL'
INDEX ON DMOVIMENTACAO TAG DMOVIMENTA
INDEX ON IDPRODUTO TAG IDPRODUTO
INDEX ON DELETED() TAG DELETADOS
INDEX ON IDPRODUTO+DTOS(DMOVIMENTACAO) TAG MOVPROD

The first error ocurred is:
Database is invalid. Please validate.

:-(