Mike
Foxpro padds char fields with spaces and there is not much you can do about that. There are some choices though. 1. make the columns in the database varchar > 255. That will make the cursor a memo and they are trimed (Yuck). 2. Use Sql pass through and roll your own updates and inserts that way you can alltrim() char fields (this is what I do). 3. Use cursor adapters in vfp8. There is a way to trim the data before sending it back to the database.
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement