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.