Hello,

I am encountering a problem with data buffering.

I have a listbox control whose source is an array that is created from a SQL statement (I am using two fields from a table).

With data buffering turned on, I allow a user to add a new record to a table or to edit an existing record. If the user adds a new record, I save the values in some text controls and then issue an INSERT INTO command which adds the new data to the buffered table. I then issue a TABLEUPDATE() command which commits the data. If I then re-issue my SQL-SELECT to update the array for the list box, everything is okay. The listbox reflects the new data.

However, if the user just edits one of the fields the list box does not get updated! Basically, if in edit mode, I just issue a REPLACE command and then a TABLEUPDATE() to commit the changes. If I view the table prior to re-issue of the SQL command, I can see that the modified data is now in the table. However, it appears that the SQL statement is only working on some already stored data and not the actual table. I tried re-dimensioning the array to nothing and then running the sql command, but still the same results. Do I need to actually close the table and re-open it to get this to work?

Thanks for any help...douglas