Do you mean something like my CABuilder PRG does for SQL Server and Oracle? It builds a class lib with a CA subclass for each table in the DB. IF so, do you have SQL code that would retrieve meta data from BTrieve regarding the list of tables or does VFP's SQLTABLES() work for that? Secondly, do you have SQL syntax that would return the table structure data including column name, data type, column width and, if numeric, precision (# of decimals)?

I am working on a new builder for CAs in VFP 9 that is data driven and extensible. So if this would work for you, and you can figure out the SQL, I can most likely help out.

>Hi,
>
>In order to access Btrieve data via cursor adapters (read only) I need a routine that will set up the CAs.
>
>Any suggestions? The data is already available through ODBC.
>
>TIA,
>
>Alex