UPDATE: I found the table the causes the Error 10 Syntax Error.
The table has 0 records. When I Validate Database I get messages that seem to point to missing index tags for this table. Then I Validate Table Recover and choose to delete the missing objects. But as soon as I try to Reindex this table, the problem (Error 10 and Object not found in Validate Database) reoccur. Still mystery.
>I have a routine in my application that calls method reindex of the Stonefield SDT. Here is the code I have:
>
>
>lRetVal = oMeta.oSDTMgr.Reindex("MYDATABASE!")
>
>if !lRetVal
>
> =messagebox('Table Indexing Failed. ' + chr(13) + chr(13) + ;
> 'Error No.: ' + alltrim(str(oMeta.aErrorInfo[1,1])) + chr(13) + chr(13) + ;
> 'Error Message: ' + oMeta.aErrorInfo[1,2],48,'Problem Indexing Table!' )
>
>endif
>
>
>If I select/check each table one at a time, Reindex works fine. But if I check All Tables, I get error 10 Syntax Error. It is hard to see which table causes this error. But by closely watching the screen it goes almost to the very last table.
>
>Any suggestions to what maybe causing this Error 10 Syntax Error?
>
>Thank you
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham