>I can't get a set of rows with select-sql, when they're just added to a table that hasn't been updated, and which buffer mode is set to optimistic table buffer.
>
>Is this by design, or there is a solution. I need both, in order to check some business rules on the record set before update the table, or should I suppose that select-sql always open tables even if they're already opened, and that's why the just added records aren't found ?


Marcelo

Remember buffered tabled still have their new recs in a buffer. They have not been added to the physical table yet. Especially if that table is on a server & you are on a workstation. Remember you can recognize buffered recs because they have a negative rec number (ie: recno() = -1).

HTH
Tom