General information
Category:
ActiveX controls in VFP
same question - how do you run the insert?
>I am developing a program that takes data from VFP 6.0 tables and inserts it into an Access 2K database. Everything is going in except I get trailing spaces at the end of character fields. For example there is a field named "Color" in the Access database defined with a field size of 20. I insert "Red" into this field and there are 17 trailing spaces. ALLTRIM doesn't make a difference. If anyone can tell me how to remove these spaces, I would greatly appreciate it.
>
>Thanks,
>Steve
Previous
Next
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