Table Design issues

rbuser

Most demos are for report files so I have a few questions

Can we store the template in a CLOB within oracle instead of a BLOB?
We wish to be able to search as text from a web application not from Delphi.

Can we run/ call a report from an ID instead of having to use a name
and a name path?

We wish to start RB without going through explorer, and open to a new or
an existing report depending on the situation. Is there a demo?

Regards
Charles

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Charles,

Sorry for the delay in your previous response. I have been researching if
templates can be saved and loaded as CLOB fields. Unfortunately I have been
unsuccessful so far. It seems that as the (ASCII) template is loaded, the
information read is gradually becomming corrupt. This is causing errors. I
would recommend trying this yourself and seeing if you have more luck than I
do. I have not worked with CLOB datatypes in the past.

It is possible to manually load the template stream into a report object.
This way you would be able to save the templates in your own table with ID's
to properly access them. Then as you need to load them, simply load the
BLOB field into a stream and then load the stream using the
Template.LoadFromStream routine.

If you are running the server edition, take a look at the demos located in
the \RBServer\Demos\Clients\03. Client Report Catalog\... directory. This
shows how to access reports without the use of the report explorer.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico

I will have a look into your sugestions.



Regards
Charles

--- posted by geoForum on http://delphi.newswhat.com