Memo Data Type

[Steve95]

Hi All

I am using CRXi and creating a report with sql backend. One of the fields is a memo data type which when put on the details section of CR nothing appearing. I have tried to convert to str and totext but no joy.

Does anyone know how to make this field appear?

Many Thanks in Advance
Jazz

 

[synapsevampire]

I guess by SQL backend you mean SQL Server. SQL is a database language, not a database.

If you're certain that the field contains data, there may be a connectivity issue with ODBC, so a CAST or CONVERT in a SQL Expression might resolve this.

-k