I have a need to update the customer number of 29 related btrieve tables running under Pervasive SQL 2000. I am using VFP 6. I have attempted several times to test the update to just one file before I write the loop of code that will update all 29. The problem is that if I key in:
DBSETPROP("myViewname.cus_no","Field","KeyField", .T.)
DBSETPROP("myViewname.cus_no","Field","Updatable", .T.)
DBSETPROP("myViewname","View","SendUpdates",.T.)
Replace Cus_No with lcNewNumber
TableUpdate()
(The first three are taken right out of Client/Server Applications with Visual FoxPro and SQL Server by Urwiler, DeWitt, Levy and Koorhan, p.66)

I get get no errors, but the field cus_no is NOT updated in the underlying table (.BTR file).

If I leave out the first statement, I get "No key columns specified for the update table "TheRealFileName". Use the KeyFieldList property of the cursor"

Is it not possible to alter the key field in a btrieve file? Or am I doing something wrong here? I really need to find a way to get all these custmer numbers changed to a a new numbering scheme. Help!

Barbara