IBX and FIBPlus

rbuser

Hi,

I use:
RB 10.07 Enterprise Edition 10.07 (serial number DM-0710-Ent1007-012)
D2007 Enterprise (December 2007 update)
Vista business Edition

I have several reports created with a my EndUser system with IBX component.
I have modified my EndUser system because I want to use FIBPlus component. I
create a new report and it's ok, but if I run my old report (developed with
IBX) I have a error.
It's maybe because the properite 'Session Type' (IBXSession / FBISession) is
recorded in the report.
How can I resolve this problem ?

Jean Pierre

nicocizik

Hi Jean,

You are going to need to change the session type before running the report
in order to use the proper DADE plugin. The best place to do this would be
after the temlate is loaded in the TppTemplate.OnLoadEnd event.

----------------------------------------------
Tech Tip: Using Template Events
----------------------------------------------

The Report.Template object has several events that can be used for
customizing what happens when a report is loaded or saved:

- OnLoadStart
- OnLoadEnd
- OnNew
- OnSaveStart
- OnSaveEnd


The OnLoadEnd and OnNew events are often used to perform actions related to
report and data initialization.

The OnSaveEnd event is often used to save additional descriptive ("meta")
data to the database each time the report is saved.

Example:

The Report.Template events are public and therefore must be assigned at
run-time.


1. In the private section of your form declaration you can declare an
event-handler method:

TForm = class(TForm)
private
procedure myTemplateOnLoadEndEvent(Sender: TObject);

public

end;


2. In the Form.OnCreate event, you can assign the event-handler to the
event:

procedure TForm1.FormCreate(Sender: TObject);
begin

ppReport1.Template.OnLoadEnd := myTemplateOnLoadEndEvent;

end;


3. Implement the event-handler method:

procedure TForm1.myTemplateOnLoadEndEvent(Sender: TObject);
begin

{add code here to initial the report or data, etc. }
ppReport1.PrinterSetup.MarginTop := 0.5;

end;


--
Regards,

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

nicocizik

Hi Jean,

Sorry, there is a bit more to this than simply chaning the Session type.
Take a look at the following article on converting templates from BDE to
ADO. The same concepts apply to your situation.

-------------------------------------------------
Tech Tip: Convert BDE Template Dataviews To ADO
-------------------------------------------------

Currently when DADE is used to create dataviews, the DatabaseName is stored
as part of the query definition. (This is consistent with Delphi's approach
to specifying a database connection for a Query object).

When you created the reports originally, the daDBBDE.pas BDE DADE plugin was
used. Now you want to use ADO. You've already changed the
Designer.Datasettings but this had no effect on the old reports. They still
try to use the BDE connection. Changing the Designer.DAtaSettings only works
for new dataviews that are created, because the new query dataviews are
using the daADO.pas ADO DADE plugin.

In order to convert the templates from BDE to ADO, at the minimum you have
to change the database name and the DADE plugin class names that are stored
in the templates. When a BDE dataview is created, its class type is a
TdaBDEQueryDataview. When an ADO dataview is created, its class type is
TdaADOQueryDataview. These class types are stored in the template. These
have to be changed before the template is loaded into a report.

First, compare a BDE report template to an ADO report template which both
connect to the same database table. Save a BDE and an ADO based report
template to separate ASCII text files. Now compare the dataview definitions.
Change the TdaBDEQueryDataview class name to TdaADOQueryDataview in the BDE
template. Change the BDE alias to your ADOConnection object. Then compare
the table name and field names of the BDE template to the ADO template and
change them accordingly, removing the .db extension on the table name is
necessary. Now load the converted BDE template in your ADO end user
application.

The first step is to make a backup of all your templates before continuing
with a programatic approach. You can convert the templates programatically
by loading the ASCII template files to a TStringList object. Then loop
through the lines of the list and change the text programatically. You can
loop through the files in a directory using ppFileUtils.pas calling the
GetFileNamesForDirectory procedure to load the file names.

If you have binary report templates, you'll also be able to convert these
with an extra couple of steps. You can load the binary template file into
ASCII format, modify it, and then save it back to binary as shown in the
example links below. Keep in mind the conversion is performed without
loading the report template into a TppReport.


This example shows how to load reports stored to the ReportExplorer database
tables and convert them to ascii text.

http://www.digital-metaphors.com/tips/EditTemplatesAsText.zip


This example shows how to convert an .rtm file to asii text


http://www.digital-metaphors.com/tips/ConvertBinaryTemplateToASCII.zip

--
Regards,

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

rbuser

Hi Nico,

I have modified, your 'EditTemplatesAsText', I added a fonction Find 'IBX'
and Replace by 'FIB' and all is ok :-)
Thank you very much for your help.

Jean-Pierre