>I gave the cursor adaptor a spin today. Created a new form, opened the DE, added a cursor adaptor. Then I attempted to use the CA builder. Setting up the connection string for ADO was a cinch. However, the second tab in the builder things not so rosy. I select one of my SQLServer 2000 tables, clicked OK, and was greeted with "CursorSchema can not be more than 255 characters." > >The question is why? Basically you have to laboriously change everything in the schema to very short, unreadable names like f1 c(100). And even at that you will still run into situations where it is not enough. > >Perhaps I have the wrong idea as the application of the cursor adaptor?? > >Regards, >Carl
AFAIK its not with Cursor Adapter, but with the properties sheet limitation to 255 characters. You should be able to change it in code without problems.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry