Message
From
16/12/2006 14:34:29
To
16/12/2006 14:22:08
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178286
Message ID:
01178288
Views:
14
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:
>
>
>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 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
"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