Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CA UpdateNameList not saving properly
Message
 
 
À
20/07/2009 04:58:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01413349
Message ID:
01413355
Vues:
57
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform