I'm having a problem where the results from an SQL SELECT statement
are returning nothing, despite knowing there is data in the table.

Here's the situation:

I have a table that is being accessed from a current form.  The table,
tw_names, has buffermode = 5 (optimistic table buffering).  If upon
adding a record, I browse the table, the data exists.  However,
if I perform

     SELECT * FROM tw_names INTO CURSOR curTW_names

the resultant cursor is empty.  Apparently, SELECT will not work on
buffered records.  I guess I could use Xbase commands, but I'd really
like to keep this exercise simple.  My objective is to load a
listbox with the generated list.

Tom

Tom, SQL works on the disk-version of the table, and Browse works on
the local buffer.  Be sure you do a TableUpdate() before calling your
SQL code and you'll get all the data.

Barbara Paltiel

I would think it would work if you commited changes i.e. tableupdate()
or maybe you don't want to commit changes.