>While i was trying to connect to an Oracle Dbms i run into a limitation of the cursoradapter with the message
>
>the cursorschema propert cannot be longer than 254 characters
>
>Allmost all our tables schema are more than 254 characters. Is there a workaround
>
>Dimitris

Dimitris.
You need to populate the schema and the 2 fieldlist fields (UpdateNameLIst and UpdatableFieldList) programatically. Visually you are too limited. You can do this very flexibly by getting an empty cursor 1st and skipping through all of the field names to populate properties. Each of the 3 properties get populated differently but this way you don't have to know what the fields are. The other BIG problem we hit was the fact that we had auto imcrementing Primary Key fields. On Insert commands those fields must NOT be in the 2 fieldlist properties, but on Delete & Modify commands the MUST be in those 2 properties. Sort oa a catch 22.

I have a doc on this and how we solved it, if you want. It was with the Beta version, not the new release. You can probably cut and past from it if you want. Just email me and request it. The same goes to anyone reading this thread. Just Email me.

Sending our base class might not help you because it is based on Doug Hennig's Cursor Adaptor class from Whilfest, not on the standard Cursor Adaptor. In fact, if you are just starting with the CA's I highly suggest starting with his. It contains some things like UPDATE, RELEASE,GETDATA methods that do thinks for you and make it easier to get started. He's had several articles in Foxtalk so if you get that mag you download his stuff.