Problem in table item with fieldtype blob in field template

rbuser

We have use in table item in field template the oracle-type long raw. But
oracle say bether is the typ blob. Now we have converted the field template
from type long raw to blob. The Reports we have copy with the SQL-Command
"ALTER TABLE ITEM MODIFY (TEMPLATE BLOB)". The problem is now the reports
can not be open. We become the error: "class mmHeight can not be found" by
the funtion LoadReports. Please help.

digitalmetaphors

We have only tested Oracle to work with the field types that we suggest in
our demo (the long type you were using). We have not tried to convert the
templates to the BLOB field type. It sounds as if the ALTER TABLE call
hoses the data, so it becomes corrupt.

Can you create a new report, save the template to this new field type for
the item template field, and then load the template back into the report? If
that works, then you'll have to find a different way of moving the templaet
data to the new field type. Perhaps create a new table and load the reports
in code from the original table and save them to the new table. Maybe that
would be a better way to move the template data to the new table field type?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

If one uses Blob for the template field as data type in table Item, there is
error while the loading of the stored reports apparently starting from a
size of 12 KB. It is all the same whether one an existing report or into the
Blob field template stores a report again put on. One opens a report from
the Template field missing characteristics with totally shifted designation
is announced.

digitalmetaphors

If new templates won't work with the BLOB data field type, then don't use
that type of field for your table. When we built the Oracle end user
database demo, we tried to use all the fields to see what worked and what
didn't. We recommend using the Long field type as you were using earlier
and as shown in our SQL script for oracle to create the end user tables.


Cheers,

Jim Bennett
Digital Metaphors