I'm setting up my first C/S app that has VFP (7) on both the front and back ends, and running into a problem when trying to add a record to the remote view, to pass back to the actual table.
The problem is that the table won't accept null values in the primary key, so the TABLEUPDATE is returning false.
Of course, that's not the problem - it's just the symptom. The actual problem (as I see it) is that the DEFAULT values of the fields (including the PK) in the back-end data don't get populated when I add a record to the remote view.
So how do I get around this? The view is defined properly, I believe - all updates are sent from the view, and the DEFAULT values work properly when I work on the back-end table directly.
The most obvious part of this problem affects the PK field (in each table), but it will also affect the default values in other fields.
TIA,
Mark