General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I get this same problem when writing to Oracle tables with VFP Remote Views, and I'd like to know if anyone knows how to prevent this as well. Maybe it's the same solution for both Oracle and Access?
>I am writing to Access2000 using the ODBC drive and VFP7. The data gets written correctly, but somehow it always gets written as the maximum field length for the Access Table. In other words, if Name is the Access Field name and it has a max width of 50 and I attempt to write 'TOM' into name the lenght of 'TOM' in the name field is always 50 rather than 3. Is there any way around this? Thanks.
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