[Valentina-studio] Non-SQL record browser

[Klamp, Kurt]

> >> 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 
 
why not? second pane popup shows the possible linked tables to the tables
used in first pane( 1.pane must always get recids of used tables). User
decides to see addtional data in linked table by choosing it in popup.
General: the routine in 2.pane looks for possible linked tables and if its
possible to show them it offers it in the popup

> or result of GROUP BY...
> 
yes, or?
if i do a query with aggregate function in 2 tables and result which is
grouped by recid of one table, why not show in 2.pane additional data of
3.table which is linked to grouped data table.

> > 
> > 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.
> 
That would be great. In first pane i've table 1, in second pane table 3 and
link table 2 isn't visible and records in linktable 2 were created
automaticaly by Vstudio.


> 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, 
Kurt