>Hello again!
>i have this statement that runs when i press a button
>
>SELECT * FROM mainbase!v_loansecure WITH (BUFFERING = .t.) WHERE type<>"B" INTO table test
>SELECT test
>browse
>
>the problem is when i browse the last value i added isnt shown unless the form is reloaded
>but im confused because i have other statements such as this one. and they work fine i do my select and browse and the data appears the same second is this because im using a view?
Yes. View keeps a copy of the records in its own buffer - the changes need to be written back into the source table using the tableupdate() function. Even without the views, as you saw already, the changes aren't written into the table immediately, unless there's no buffering. Check cursorgetprop("buffering") in help, and setting it too.