Subject | Re: [IBO] Suggestions for IBO v4 |
---|---|
Author | Geoff Worboys |
Post date | 2000-12-06T01:11:54Z |
> would be nice to have an "in memory table" component simulatingI had a thought about this, but have not investigated the full details
> the properties and behaviour of TIB_Query (with a fields editor).
yet...
I have a stored procedure that takes FromDate and ToDate parameters
and cycles through the dates in the range, returning a record for each
date. It would be easy enough to create an equivalent procedure that
does the same for integers - giving a skeleton of a table with an
integer primary key (but no other fields).
At the client you create additional fields using Calculated fields.
All we need then is for the Calculated fields to be (optionally?)
editable - this was discussed recently, I dont know what the outcome
was. The calculated fields can then be populated from a stringlist or
whatever - the "in memory" table.
There are obviously details to be worked out, but how does something
like this sound? It provides a form of in memory table that *may* be
able to be implemented with minimal impact to the underlying code.
Jason, what do you think?
Geoff Worboys
Telesis Computing