Tableupdate failure-index does not match.....

I have a parameterized view. I put a few records in it. I update the
records. I issue tableupdate. If I don't update the first record in the
view, the tableupdate fails, and aerror() shows me Index does not match the
table..., error 114. I know for a fact that there is nothing wrong with the
index, and this only happens if I don't enter a value in the first record.
I've seen this before, but don't remember where or when. Anyone recognize
this issue?

Ook
Wed Mar 28 11:10:14 CDT 2007

My bad, I'm not actually using a view, I'm using a buffered table.
I've seen similar errors where the first field is blank and Fox can't
determine the width of the column. However in this case, I'm adding
records to a table, and editing a non-indexed field.

I add the records, do a sucessfull tableupdate. I perform several
queries on the table, and another tableupdate gets issued. The second
tableupdate fails with "Index does not match the table. Delete the
index file and re-create the index.". Between the first and second
tableupdate, no table modifications occur. Why would Fox think the
index has gone bad?

On Mar 27, 6:38 pm, "Zootal" <nousenets...@zootal.nospam.com> wrote:
> I have a parameterized view. I put a few records in it. I update the
> records. I issue tableupdate. If I don't update the first record in the
> view, the tableupdate fails, and aerror() shows me Index does not match the
> table..., error 114. I know for a fact that there is nothing wrong with the
> index, and this only happens if I don't enter a value in the first record.
> I've seen this before, but don't remember where or when. Anyone recognize
> this issue?

Ook
Wed Mar 28 13:28:31 CDT 2007

Mystery solved. Someone added code to index a view, and when the view
is requeried, the indexes no longer match the view. So, in this case,
the message is correct - the index really doesn't match the table.