Index-by table

[F.Hinlopen]

I am doing some heavy server-side programming which also involves a number of index-by tables. What I would like to see is a DataSet-like interface to such tables so I can view/manipulate them from the client as well.
Am I overlooking something, or have I just invented the server-side TClientDataSet

?

------------------
Frans

 

[Marco Kalter]

What exactly would this dataset do when the data from the PL/SQL Table(s) is fetched, updated, inserted and retrieved? Is this a global variable in a package that needs to be manipulated? Or are there specific stored functions and procedures for this?

------------------
Marco Kalter
Allround Automations

 

[F.Hinlopen]

The index-by tables to be viewed (and possibly manipulated) are global variables in a package. For the short term, I am going to pull the contents to an in-memory dataset clientside (not TClientDataSet btw, since I am on BCB Pro) using the collection methods FIRST, NEXT etc. This is a lot of work however, so having a component for this would be really nice. I would have a go at implementing this myself, but life is short (especially since I have no idea how to discover the datatypes of the fields of the index-by table)!

------------------
Frans