>I have a paramatized remote view (SQL Server). Sometimes - not always - when I add a record it disappears from the form. I do an insert into the view with the PK and then enter the rest of the data. The save does a tableupdate that returns .T. (buffering = 5). The textboxes bound to the fields go blank. When I try to browse the view in the datasession (private), I get an error message "Index does not match table. Delete the index file and recreate the index." When I exit the form and go back, the record is there.
>
>My views have no indexes. How can I get this error?
Just guessing: could the message be coming from a damaged index in the underlying table? Or could you accidentally have a stray index with the same name as the view's name or alias somewhere along the VFP path.