
How can you SQL Select buffered tables
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