text datatype to memo?

[rsknut]

Hi,
I am having troubles with Crystal changing the datatype of my text254 fields to a memo datatype. Why is this? The text254 field is a PeopleSoft 8.4 field and is a mixed case character field of length 254. When I verify database it will not recognize the text254 fields as strings but rather as memo type fields. Any suggestions?

Crystal 8.5
PeopleSoft 8.4

Thanks in advance!

 

[synapsevampire]

Use a SQL Expression to explicitly cast them.

-k