>I have a form that has a table in it that doesn't get the index updated when a record is added. The form is setup as a private data session and buffering set to optimistic. The table is setup with optimistic row buffering. The data is in the table. Set order to allows you to view the record that was added. Set the order to any of the indexes on the table and you can not view the record. Does anyone have any suggestions for a fix?
>
I'm surprised noone has mentioned it yet, but do you issue a TABLEUPDATE() both against the view AND the table? The index is only updated when the data is committed to the table; in this case, TABLEUPDATE() against the view commits the data to the table's buffer, but not to the table itself.