>When I use CursorAdapter, I can't correctly set SelectCmd & CursorSchema properties in designer, since max lenght of property is 255, but lenght of my SelectCmd is 872 (I use long field names in tables). Same situation with CursorSchema. I can assign this properties in code, but then i can't able to drag and drop fields from the CursorAdapter & so on. Anyone can help to solve this problem?
The best you can do is set these properties using code. As for the CursorSchema, you could put a partial schema in the property that contains the most likely fields to be needed for drag-and-drop. Then still replace this schema with the full schema using your code.
FWIW, if you are using native tables, you can add the tables to the project manager [just exclude them from the project], then you can drag fields from the PM and drop them on your forms.
Mark McCasland
Midlothian, TX USA