Re: ACE Report Question

>From: cwh@evolving.com (Chris Hushour) >Date: 5 Mar 1995 22:55:33 GMT >X-Informix-List-Id: <news.12000> > >I'm using ACE to write a report for one of my customers. One of the fields >I need to output in the report is a blob text field. In order to output >this field, I need to store it in some type of ACE variable. Well, presumably you will be selecting it from the database, won't you? So part of your final select will be: SELECT ..., textblob, ... FROM ... You immediately have a text blob variable called textblob which you can print. >I've tried assigning this field to a character variable of size 10,000, >but ACE tells me that this variable is not large enough (makes sense since >a text field can be of unlimited size). I've tried using the CLIPPED >keyword, but I get an error telling me that this can only be used for >character fields (not text fields). You can't manipulate blobs inside the report, of course, unless you write C functions and call them inside the report -- you'd also need the custom ACE runner. That includes assignments. All you can do is SELECT them and print them. You shouldn't need to use CLIPPED on a text blob. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>