Yes SELECT always will return the old values till the VFP8, in VFP 9 there is a clause WITH BUFFERRING = .T. that allows you to select from buffered data.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.