Page 1 of 1

Memo fields and scanning tables

Posted: Mon Oct 24, 2005 3:31 pm
by leibyj
I have two questions:____1. Is there a way to convert memo fields into character fields? I need to use certain character functions on a memo field.____2. When running IIF statements, how do you make sure its checking every listing in the table?____Thank you

=> RE: Memo fields and scanning tables

Posted: Mon Oct 24, 2005 3:46 pm
by kfleming
The SQL version treats memo fields as character fields.____An IIF() calculation will be applied to each composite record in the report.____Kathleen__R&R Support

==> RE: Memo fields and scanning tables

Posted: Mon Oct 24, 2005 3:49 pm
by leibyj
What if you^re using Xbase edition?

===> RE: Memo fields and scanning tables

Posted: Tue Oct 25, 2005 9:02 am
by kfleming
In Xbase there is not a way to convert from memo to character or to use character functions on memo fields.____Kathleen__R&R Support