I found the same behavior, see message #
1411615>Hi Experts,
>
>I currently use the CursorAdapter class to access MySQL tables.
>
>Everything seems to be fine till today. When I changed an existing table structure (by changing a field name and increasing its field width and adding a new field), I then proceeded to change the CA class definition of that table.
>
>Upon instantiating the CA class, it fails its CursorFill method (return FALSE)!
>
>When I go back to my CA class for that table, I always find the UpdateNameList messed up! But messed up, I mean the enumerated list is not exactly the same as I left it. The end part seems to get 'jumbled!
>
>The correct one should be:
>
>CODE student.CODE, LASTNAME student.LASTNAME, FIRSTNAME student.FIRSTNAME, MIDDLENAME student.MIDDLENAME, CHINAME student.CHINAME, FAMILYID student.FAMILYID, GRADELVLID student.GRADELVLID, SECTIONID student.SECTIONID, ISELDEST student.ISELDEST, ISENROLLED student.ISENROLLED, 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, ID student.ID
>>
>Upon saving, it turns into this:
>
>CODE student.CODE, LASTNAME student.LASTNAME, FIRSTNAME student.FIRSTNAME, MIDDLENAME student.MIDDLENAME, CHINAME student.CHINAME, FAMILYID student.FAMILYID, GRADELVLID student.GRADELVLID, SECTIONID student.SECTIONID, ISELDEST student.ISELDEST, ISENROLLED student.ISENROLLED, 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.CITIZECODE student.CODE, LASTNAME student.LAS
>>
>Notice the weird result in boldface.
>
>Jeeezzz... please help!
>
>Dennis
If it's not broken, fix it until it is.
My Blog