Yes, it is a Property sheet limitation. What I do for a workaround during development so I have "fields" to drag-and-drop" on the form is to create a dummy DBC with tables of the exact structure and alias names I am going to use in the CAs. I then add these tables to the DE along with the CA. There is no conflict of names because my CA object names always start with 'adp'. After I am finished with the form, I just delete the table from the DE.
I use my CA VCX Builder to create a CA for every table in my database. I then run another PRG that creates the code needed to create the dummy DBC and tables. You can download all this from UT Downloads. All source code is included as well as extensive documentation in the form of comments in the CABuilder PRG file.
>Hi Everyone,
>
>Is there any way to get around the cursor adapter builders 255 character limit on the CursorSchema?
>
>I assume the limit is because of the properties window or something like that, because when I tested it in a prg it seemed to work fine (with a few other minor issues when importing into a data environment)
>
>Thanks,
>
>Michael Henstock
>AWS
Mark McCasland
Midlothian, TX USA