Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hello,
>
>I have a table with two memo fields and a logical field. I have created a view where I have contatenated both memo fields as follows:
>
>ALLT(m1)+RTRIM(m2) as mtest
>
>I have created a form with a grid. In the grid, I display the logical field and I display the concatenated mtest field. The concatenated field does not wordwrap. It just goes off to the right in a single line until the end of the text.
>
>When I display a single memo field in a grid, it wordwraps automatically based on the size of the column. I can also set whether scrollbars will be visible or not. -- with the concatenated field, there is no option for scrollbars.
>
>Anyone have an idea what is going on here? What do I have to do to get the concatenated memo fields to wordwrap properly?
What is the Grid.Column.Control? Is it a textbox, or Editbox?
Anyway I think that the way you concatenate will not give you desired result: the length of the field here is based on the very first record (string) length and all subsequent records will trimm string for longer length. I would use something like: padr(ALLT(m1)+RTRIM(m2),200) as mtest.
Précédent
Suivant
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