>>>>>Hello everybody,
>>>>> I am trying to create a view from a SQL Table, I am using the view designer in 6.0 and some specific fields are truncated to a lenght shorter than the lenght specified in SQL, it is always the next field to the first numeric field in the
>>>>>SQL table, and is only that table, any thoughs on that ?
>>>>> We tried deleting the table and creating it from scratch in SQL. But the problem persists.
>>>>>
>>>>>=THIS.Thanks("in advance")
>>>>
>>>>Luis,
>>>>
>>>>Are the lengths of the fields in the backend table greater than a specific length? Or is this appearring with some fields and not others of the same length?
>>>
>>>Yes, in the back end I have Char 25 and in FoxPro it comes with Char 20.
>>
>>I just checked this out with SQL Server 7.0 (Local). I added a column named: THISISVERYLONGCOLUMNNAMETOTESTFOR (33 characters), using the view designer that comes with VFP 6.0 (SP4) I was able to create a remote view to the table. The value I posted above was obtained by issuing AFIELDS() against the cursor returned then copying the field name into the _CLIPTEXT system variable. As you can see, all 33 characters came through just fine.
>>
>>The next place to look at, I'd guess, would be the ODBC driver and version. AFAIK, 25 characters shouldn't be a problem.
>
>I am using version SQL 3.70.06.23 11/06/1998 from microsoft, what version did you used ?

I'm using 3.70.08.20 dated 6/26/2000 from MS.