>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.
The short answer is: you can't. Data in the view that isn't commited doesn't really exist as far as SQL SELECT statements are concerned. You have to use SCAN to go through the records, one by one. Sorry. Unless somebody knows a better way than I do...