Migrate from DBE to IB

rbuser

Hi list,
is there anyway to import reports ( stored in Paradox tables ) into an
interbase database, saving everything?

Any help appreciated.
Rgds.

Paolo Fenelli

digitalmetaphors

The datasettings in the template have to be changed and the class names of
the dataviews should stay the same, because you are using the BDE to connect
and the BDEQueryDataview class will be used. If you want to use IBX, IBO,
dbExpress, then you'll have to change the query dataview class types in the
template to new one respective of the new DADE plugin you want to use.You'll
also need to trim the db extensions from the paradox tables stored in the
template.

What you can do is run both end user projects for the paradox and the
interbase and save down a template for each, in which you create a single
dataview on the same table in each database. (Report.Template.Format =
ASCII) Then open the two templates and compare the changes. These are the
changes you need to make to convert the temlpates.

If all you templates are stored in binary then you can read them up to ascii
like as shown in this tip in order to convert them easier:

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

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim,
thanks.
I take my time to try and revert

Best rgds.
Paolo Fenelli
AC SOFTWRE HOUSE
NAPLES - ITALY

rbuser

Hello Jim,
I've downloaded the file and seen. Tyed with a simple report to "translate"
to IBo and it seems to work ( I've never thought it doesn't! ).
In case i'll find problems with more complex ones i'll be back again.

Now i'd like to know, for future uses, wich is the best solution to store
report files on disk.

Best rgds.
Paolo Fenelli
AC SOFTWARE HOUSE
NAPLES - ITALY

digitalmetaphors

Storing report template files to disk has the same advantages and
disadvantages just like storing any type of file in binary or ascii would.

As far as data access suggestions, as long as you stay away from the BDE you
are doing good:)


Cheers,

Jim Bennett
Digital Metaphors