Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there limit w/ CursorAdapter UpdateNameList?
Message
From
23/09/2008 08:50:08
 
 
To
23/09/2008 07:10:00
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Miscellaneous
Thread ID:
01349746
Message ID:
01349789
Views:
20
>Borislav,
>
>>could you post the CA definition?
>
>
>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.)
>
>Thanks!
>
>Dennis


Try using TEXT ENDTEXT:
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
ENDTEXT
That way you could store more than 256 chars in property.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform