General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hello,
>
>When I look at the field properties in a remote view of an vfp 6.0 sp5 DBC it is showing me that the field type size is C(20). However, when I use
>?dbgetprop("ViewName.FieldName","field","DataType") is shows it to be the correct value of C(40). The underlying sql*server data type is Char(40).
>
>I can delete the view and rebuilt it and it still is showing c(20). This is weird. Has anyone seen this before?
>
What does your SQL select statement that builds the view look like? Fox uses the width of the first result as the column width for the cursor. So if you're trimming the field to a length of 20, it'll only create and use 20 characters instead of 40.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only