>>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.