Using RB for linear hash files (ODBC or native ?)

rbuser

Hi,

I'm looking at using D6 Pro plus RB Pro to access LH (linear hash)
files. These files/tables are very similar to Pick/Universe, and are
part of an OpenInsight (see http://www.revelation.com) application.
The data is variable length columns, and you can have what I would
call 'dynamic arrays' within any column, also variable length,
multiple levels of nesting within the 'array', and no fixed number of
elements. Hence row size os varibale as a result of the structure of
the LH data.

The software vendors, Revelation Technologies (RevSoft) do have an
ODBC driver. How can this be done with D6 Pro/RB pro combination ?
The only problem with using the Revsoft ODBC is the price, it is USD
$199 , and that is for a single user, and therefore I could not deploy
the Delphi application without having to buy an ODBC driver for every
deployment. That's my understanding, anyway.

Is there a native method of accessing the data, or any other methods,
please ?

Peter


Peter Richards
peter_j_richards@nospamplease.com (but use hotmail to email)

rbuser

Hi Peter,

you'd better ask the database manufacturer for alternatives. This group here is for questions about ReportBuilder only.

regards,
Chris Ueberall;

rbuser

Hi Chris,

On 27 Jan 2003 06:11:10 -0600, "Chris Ueberall [TeamDM]"

rbuser

Peter,

there is no need for cross-posting the question in other groups here, I think you used the best one. But I think you should ask in the 'Online Discussion' forum of revelation too. I'm not aware of any DADE plug-in for revelation.

regards,
Chris Ueberall;

digitalmetaphors

Check out the ODBC Express DADE plugin from our website, if you decide to go
with ODBC. If you find other connectivity, you can use any 'proper' TDataset
descendent with our DBPipeline architecture. If you do not find a TDataset
descendent to use, then you can try to use JITPipelines to access the data
at runtime. If you have to use an alternative plugin inside of DADE which
does not exist, then you can create a new DADE plugin for the new data
connectivity you find, or you can use custom dataview templates. There are
examples of creating them in our installed demos. You can also use
JITPipelines inside them. Here is an example:
http://www.digital-metaphors.com/tips/myJITMasterDetailTemplate.zip


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Chris,

On 28 Jan 2003 05:38:38 -0600, "Chris Ueberall [TeamDM]"

rbuser

Hi Jim,

Thanks very much for your reply.

Peter

On Tue, 28 Jan 2003 10:17:35 -0600, "Jim Bennett \(Digital