>>>>>>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.
I went to microsoft site and could not find anythinig newer than April 99,
I am using Wiidows NT 4.0, could you please e-mail me the driver as your ealiest
convenience at LGUZMAN@PDMIAMI.COM
Thanks a lot.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould