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