>Is defining a CursorSchema for a CursorAdapter class important if the data source is a native VFP8 table?

Only if you want to force VFP to use your defined schema. It is more important for SQL databases where you can define a Datetime field in SQL Servore or Oracle as a Date data type when the cursor is created.

>Also, when using the DataEnvironment builder and defining my CursorAdapter, I get an error that my CursorSchema can not be over 255 characters. Is this just a limit of the builder? If I have many fields in my table, should I create my CursorAdapter manually to avoid this size issue?

The limit is a Property Sheet limit and applies to any character property. Go to http://mctweedle.com and click the FoxPro Tools link. Download the CA VCX Builder and read all the comments at the beginning of the CABuilder PRG file. You can download the other 2 CA files and work through them to get a better feel for using the CA.

One thing my builder will do is create a CA for every table in your database [native, SQL server or Oracle]. For the CursorSchema property, it will include as many fields as possible without exceeding the 255 limit. The full schema is in code and will replace the CursorSchema property with the complete schema at runtime which has no 255 char limit.