In all case length ( fieldfiltervalue) <> field.size : fieldfiltervalue is trimed.
Med ________________________________ De : Martin Schreiber <[email protected]> Envoyé : lundi 1 octobre 2018 15:45 À : [email protected] Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for MSEide+MSEgui) On Monday 01 October 2018 17:21:11 mohamed hamza wrote: > And we must have an update table set field00=trim(:field00) into > SQLupdate of the dataset . > Why? char(n) columns always are padded with spaces to length n on server. If you don't want that use varchar(n) columns instead. The trailing spaces of char(n) columns can be removed in dataedit by activating optionsedit oe_trimright. Martin _______________________________________________ mseide-msegui-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
_______________________________________________ mseide-msegui-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
