>I know why foxpro makes the trailing spaces... It has to do with the .dbf format.
>
>The problem is that when I scatter the fields in preperation to inserting them into another table, I get trailing blanks on the fields. Then when I insert them into another data base engine (access or sql anywhere) I have errors because the blanks are there.
>
>Is there any way to scatter without the blanks? Short of m.myfield = alltrim(myfield)
>
>Thanks!
ps, even that doesn't work. I have to first convert the field type of the view to a memo field, or foxpro ODBC will pad out the field when I try to run a SPT to insert the record.
ie, m.myfield = alltrim(myfield)
? sqlexec(nhandle, "insert into mytable (myfield) values (?m.myfield)") will still insert blanks at the end of myfield unless myfield is of type "memo"
Errrr Grrrrr
--Todd Sherman
-Wake Up! Smell the Coffee!