Did you try:

SelectCmd = "select 1 AS EXP, 10 AS EXP1, ...
or

SelectCmd = "select 1 EXP, 10 EXP1, ...



>OK, I give up! What am I missing? I have a databasse on a remote SQL Server which I am trying to query using a CA. I created a CA class in a classlibrary, and subsequently used the builder to configure the class for use. When I do use it, there seems to be problems when mapping the SQL data to a VFP cursor. I have tried with both UseCursorSchema True and False. Still "No Cigar"
>