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

Known bug in the view designer. If it passes the values through at the correct length, don't worry about it. DBGETPROP() should show the correct field width. It happens when the first field in the view is a numeric or date field.