Information générale
Titre:
Problems with CursorAdapters cursor schema
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement