I guess I do not understand. I am trying to use either a Cursor Adapter or a Remote view to get to this data. I have made a view on the SQL Server which now provides aliased field names which VFP finds acceptable, but i cannot configure a view with the VFP CA builder. I tried yours as well, but your cool builder does not generate classes for SQL views.
Thanks
Glenn
>How about aliasing the field names.
>
>CREATE SQL VIEW... AS
>SELECT 1 as NewName1, 2 as NewName2,... N as NewNameN FROM...
>
>>I need to access a SQL Server database which has some fields named:
>>
>>1
>>2
>>3
>>4
>>5
>>6
>>7
>>8
>>9
>>
>>
>>No matter how I try to get to this data, I am unsuccessful. I am not very handy with SQL Server and need some help making a "View" of this data which VFP can access via either a Cursor Adapter or a remote view.
>>
>>Please help I am stumped.
>>
>>Glenn