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?

Thanks -

Don