Don,
It has nothing to do with CA. A query in VFP8 and earlier cannot see buffered unsaved data. VFP9 can with new optional clause
WITH (BUFFERING = .T.)
>I've just started using a CA against SQL and it's basically working just fine. It's fields are bound to TextBoxes which the user can update correctly.
>
>When they hit a "Save" button I SCAN through the CA's cursor and check data values, which again works fine. The TABLEUPDATE saves everything, as intended.
>
>However, when I attempt to do SELECT the contents of the CA's cursor INTO a (normal) VFP cursor, I always get the original, unmodified contents.
>
>To repeat: if, from the command window, I "SELECT caCursorName" and "BROWSE", everything looks fine and I see the user-modified data. If I say "SELECT * FROM caCursorName INTO newCursor", I get the original data back in newCursor.
>
>What am I missing?
>
--sb--