Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Adapter error. Pr. UpdateNameList
Message
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Miscellaneous
Thread ID:
01126060
Message ID:
01126061
Views:
14
A string litearal in VFP is limited to 255 characters. To avoid this limitation, you can concatenated multiple strings or assign the value in the Init using TEXTNERGE.
	UpdateNameList = "CHANNELID channels.CHANNELID, " + "NAME channels.NAME..."
>I have a class to manage a remote table in mySQL, this inherits from Cursor Adapter parent class.
>When I assign UpdateNameList property with a string large than 256 chars and compile, I get an error ("Command contains unrecognized...")
>
>
>DEFINE CLASS caChannels AS caBase OF caBase.prg
>
>	SelectCmd = "select * from channels"
>	CursorSchema = "CHANNELID I, NAME C(75)..."
>	Alias = "channels"
>	Flags = 0
>	SendUpdates = .T.
>	KeyFieldList = "CHANNELID"
>	Tables = "channels"
>	UpdatableFieldList = "CHANNELID, NAME, COMMISSION..."
>	UpdateNameList = "CHANNELID channels.CHANNELID, NAME channels.NAME..."
>	UseCursorSchema = .F.
>	Name = "cachannels"
>
>
>The line with UpdateNameList gives the error.
>Is it caused by a large string ?
>Any idea to how can I to solve it?
>
>It's strange, when I use class design builder I don't get the error when generate the schema.
>What I do is the following:
>open the class with class browser
>view code, and copy the code then paste it in my child class.prg and when compile it gives me an error.
>
>T.I.A.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform