>I am doing a select SQL from a View that is optomistic table buffered agianst one table. The values in the view are different from those in the table because I have not sent any updates to the table yet. When I do the select naming the view in the FROM clause (the table isn't open and dosn't have the same name) the result set contains the values in the table, ie the oldvalues in the view.
>
>So my question is, how can I select the values actualy in the view short of scanning it.
I am getting lost in what you are really doing. You have a view open and you have made changed to the data in the view. You have not yet done a TableUpdate to write the changes to the source table. You then do a SELECT FROM MYVIEW which gets the changed data which is still different from the source table.
I would issue a TableUpdate before executing the SELECT. If you have already issued a TableUpdate and want to make sure you are selecting the most current data from the table, issue a REQUERY() on the view before issuing the SELECT.
Mark McCasland
Midlothian, TX USA