DEFINE CLASS castudent_ AS mysqlcursoradapter Height = 22 Width = 23 UseDeDataSource = .T. SelectCmd = "select *,chiname as chinamex from student" CursorSchema = "CODE C(10), LASTNAME C(30), FIRSTNAME C(30), MIDDLENAME C(30), CHINAME C(10), FAMILYCODE C(10), GRADELVLID C(32), SECTIONID C(32), ISELDEST I, ENROLLDATE D, BALANCE Y, GENDER I, BIRTHDAY D, BIRTHPLACE C(50), EMAIL C(120), MOBILE C(30), RELIGIONID C(32), CITIZENID C(32), NOTES M, ID C(32), CHINAMEX C(10)" Alias = "student" KeyFieldList = "ID" Tables = "student" UpdatableFieldList = "CODE, LASTNAME, FIRSTNAME, MIDDLENAME, CHINAME, FAMILYCODE, GRADELVLID, SECTIONID, ISELDEST, ENROLLDATE, BALANCE, GENDER, BIRTHDAY, BIRTHPLACE, EMAIL, MOBILE, RELIGIONID, CITIZENID, NOTES, ID" UpdateNameList = "CODE student.CODE, LASTNAME student.LASTNAME, FIRSTNAME student.FIRSTNAME, MIDDLENAME student.MIDDLENAME, CHINAME student.CHINAME, FAMILYCODE student.FAMILYCODE, GRADELVLID student.GRADELVLID, SECTIONID student.SECTIONID, ISELDEST student.ISELDEST, ENROLLDATE student.ENROLLDATE, BALANCE student.BALANCE, GENDER student.GENDER, BIRTHDAY student.BIRTHDAY, BIRTHPLACE student.BIRTHPLACE, EMAIL student.EMAIL, MOBILE student.MOBILE, RELIGIONID student.RELIGIONID, CITIZENID student.CITIZENID, NOTES student.NOTES, ICODE student" && <- the problem line indexkeylist = "id" indextaglist = "id" Name = "castudent"Take note of the UpdateNameList property. For some strange reason, the builder shows the correct checked updatable fields. But after closing the builder, it seems to produce an erroneous UpdateNameList value! (This happened when I added the field CHINAME and CHINAMEX in the MySQL table then redid the CA.)