>I'm working on an existing app with 65+ views, adding some multi-language capabilities. No problem with character fields, I have a function that checks the right language and does a lookup in the translation table. I just replace the original character field with a calculated field with the same name and length containing the translated character string.
>
>However there are several dozen memo fields, most with a page or more of data. Is there any way to force the calculated field in a view to become a memo field? I can change the view but the result must have the same field names and field types as the original since I can't change the application itself.
>
>I have rather klutzy workaround involving a table with blank memo fields in a single record. The view is designed using this table. When loading the application I make a cursor with the same name and field names containing the translation information. But I really dislike having tables and cursors with the same name!
>
>Any suggestions? Better workarounds? Keep in mind that I have to work within the existing views. I can't add any code after the view is opened to update the memo fields.
>
>Thanks!
>Barbara
First of all, welcome back! Haven't seen you here for a while.
For VFP9 you can use CAST() function. In prior versions you need to have an extra table (cursor) with one blank record and a memo field to add to your query.
If it's not broken, fix it until it is.
My Blog