>We have seen wierd problems when the field order in a remote view does not match the field order in the SQL Server Table. The structure of the remote view gets toasted in the DBC. If we recreate the remote view with the fields in the proper order, everything works fine. Is this a known bug? I have not been able to find any info on it.
>
>We are using VFP 6.0 sp1 and SQL server 7.0
>
>Thanx

I Fred,
We have the same problem. I don't know if it happens in SQL 6.5 also but I believe it does.