>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" > >>
TEXT TO this.UpdateNameList PRETEXT 15 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.ICODE ENDTEXTThat way you could store more than 256 chars in property.