Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA UpdateNameList not saving properly
Message
 
 
To
20/07/2009 04:58:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01413349
Message ID:
01413355
Views:
56
Looks like the same problem as discussed in 'Is there limit w/ CursorAdapter UpdateNameList?' Thread #1349746 Message #1349883

>
>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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform