>>>>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 ?
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould