Hi Naomi,

I was half expecting to see how you are retrieving 'EMail' field.

You said 'calculated' field, it is not the case of the length of the first item controlling the size of the field is it?

Mathias

>Hi everybody,
>
>We have calculated fields in our People table called EMail, CellPhone, HomePhone, OfficePhone. I set all these fields to be Memo. Now, for some unknown reason the e-mail field only displayes 4 first characters.
>
>Here is the script that creates this field
>

>lparameters tcCustomerID
>
>local lnSelect, lcSelect, lcPhones, loDatabase
>lnSelect = select()
>if not used('curEmails')
>lcSelect = "select cID, Phone, Type from Phones " + ;
>  "where Type LIKE 'E-mail%' and Phone <> space(60)"
>loDatabase = SQApplication.DataEngine.Databases.GetMainDatabase()
>loDatabase.ExecuteSQLStatement(m.lcSelect, , 'curEmails')
>select curEmails
>index on cID tag cID
>endif
>
>lcPhones = ''
>select curEmails
>set order to cID
>if seek(m.tcCustomerID)
>scan while cID = m.tcCustomerID
>  lcPhones = m.lcPhones + iif(empty(m.lcPhones), '', chr(13) + chr(10)) + trim(Phone) + ' ' + strtran(trim(Type),"E-mail","")
>endscan
>endif
>select (m.lnSelect)
>return m.lcPhones
>

>
>Do you know what could be wrong?
>
>Also, we tried to apply specific width and cut off, show ellipsis at the end setting, but no dots were shown even with data cut off.
>
>Thanks a lot in advance.