Mark,

Thanks for the offer. Although I solved this problem using remote views I can keep looking if you want me to so you can improve CABuilder. Would you like me to try?

I have the help file but am not able to test because the system files of the accounting package are protected.

Alex

>Small correction. What I need is syntax to get the list of tables if SQLTABLES() does not work for you. The other SQL I need is the syntax to get information on the primary key columns. For SQL Server this looks like:

>SELECT
>	TC.Constraint_Type,
>	TC.Constraint_Name Index_Name,
>	TC.Table_Name,
>	CCU.Column_Name
>FROM Information_Schema.Table_Constraints TC
>	JOIN Information_Schema.Constraint_Column_Usage CCU
>		ON TC.Constraint_Name = CCU.Constraint_Name
>WHERE Constraint_Type = 'PRIMARY KEY'
>ORDER BY TC.Table_Name

>
>>Thank you very much. I have downloaded CABuilder and a version for Btrieve is exactly what I need :)
>>
>>Let me investigate and get back to you.
>>
>>Alex
>>
>>>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.