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--