I'm currently using Visual FoxPro6 with a Sybase database. In an effort to trim down the size of our database I'm trying to remove the padding that fox does with it's remote views. A quick example of this would be:

open data database
use v_tablename
append blank
replace columnname with '333'
tableupdate(.T.)

Even before I do the tableupdate '333' == columnname returns false. The view is padded to the length of the field after each update. If all these spaces are sent to the database it seems the size of the database would be close to double what it could be without them. Ideally I'm looking for a foxpro solution for this..but if anyone has run into this problem had found a database solution I'm more than willing to try it at this point.

Thanks,

Mike