AW: [Valentina-studio] Non-SQL record browser

[Ruslan Zasukhin]

on 7/28/03 12:04, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

>>>>> Such browser allow do not-trivial navigation between
>>>>> RELATED records of tables. And it is ready from start, user do not need
>>>>> create any layouts...of course we can try to invent way how allow
>>>>> users tune
>>>>> browsers for him.
>>>> Maybe we can have another pane in the current record browser which can
>>>> be opened by a button "Show related" - ...
>>> 
>>> I think not so easy.
> 
>> Why not with second cursor ?
> 
>> Second pane has popup with related tables (objPtr) and choosing a related
>> table will build second cursor (select */** from relatedtable where
>> recid=objptrfld) on the fly and show related recs depending on selection in
>> first record pane. Like in Vapp but with cursors. Valentina must be fast
>> enough to do so without waiting for recs, at least for the first 5-10 recs
>> depending on the size of the second area .
> 
>> Even things like show 'selected/show free' is possible
> 
> Well, Kurt, probably you are RIGHT !!!!  :-)
> 
> I see just one limitation. Selection in the TOP browser must be selection on
> SINGLE table, i.e. This CANNOT be JOIN TABLE or result of GROUP BY...
> 
> Jochen, I think this really can work...
> Just later we will need more abstractions for this level.
> 
> Deal is that I want support in this way, NOT just ObjectPtrs, but ANY kind
> of link between 2 tables:
> 
> 1) ObjectPTr
> 
> 2) RDB Link 
>     a) default FOREIGN KEY in SQL and RDBMS
>     b) LINK condition assigned by user on fly.
>           Just only. To see something.
> 
> 3) New kind of link that can be M : M.

And ... :-)

This is than more can be done, because in 2.0 C++ design
Cursor object exposure as I_Cursor interface, so I_Table interface.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------