As many colleagues have said in this forum, Cursor adapter is a wellcomed feature. Unfortunetelly i found it unusable due to the lack of documentation, to the unhelpfull error messages (i.e. when you make a mistake in the cursorshema you get a syntax error with out mentioning anything else) and ofcourse one of the biggest issues is the 254 property limit. Almost none of our remote tables pass this limit. And while i am working with this class i am discovering more and more undocumented idiosygracies. Trying to figure out the last one i lost almost 2 days only to discover what is happening :

cursoradapters Cursorschema does not accept carriage returns between the comma delimited list.

This following works:

text to This.CursorSchema NOSHOW PRETEXT 7
EMZ55AADR1 C(40), EMZ55AADR2 C(40)
ENDTEXT

SET TEXTMERGE ON
text to This.SelectCmd noshow
SELECT
F5549T05.EMZ55AADR1,
F5549T05.EMZ55AADR2
from F5549T05
WHERE EMZ55SUNO = <>
endtext

but the following does not work !!! Notice that the SelectCmd has no problem with the carriage returns ...

text to This.CursorSchema NOSHOW PRETEXT 7
EMZ55AADR1 C(40),
EMZ55AADR2 C(40)
ENDTEXT

SET TEXTMERGE ON
text to This.SelectCmd noshow
SELECT
F5549T05.EMZ55AADR1,
F5549T05.EMZ55AADR2
from F5549T05
WHERE EMZ55SUNO = <>
endtext

Thank you