>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.
HiCarl.
This is a repetitive problem. Everyone is confronted with it when they first use the builder. Populate this property in code and it doesn't present a problem. You will need to populate the UpdatableFieldList and the UpdateNameList properties also. If you make a base class which creates an empty cursor, then populates these properties utilizing the cursor structure, then you can sub class it and use it for any table.
- Glen -
The impossible we do immediately.
The miraculous will take a little longer.