[Valentina-studio] Non-SQL record browser

[Ruslan Zasukhin]

on 7/28/03 13:56, Klamp, Kurt at Kurt.Klamp at abdnb.bayern.de wrote:

>>> 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
>> 
>> But JOIN TABLE, is not equal to original tables.
>> This is NEW table. It is NOT linked to others table, and it have NO such
>> info.
>> 
> Sorry Ruslan, but i don't understand it yet.
> 
> Assume there are 3 tables
> Table 1: Person
> -Name 
> -Age
> Table 2: Results
> -date
> -points
> -objptr to person
> Table 3: Adress
> -street
> -city
> -zip
> -opjptr to person
> 
> and now i do a query in first pane like 'select * from person, results where
> points>50
> Why not see in second pane the linked data to first pane record like
> 'select * from adress where person.recid=objptr_to_person' without entering
> this sql string, because for each record in first pane there can be
> found/linked data in table 3 ?

Well, this  kind of query may be yes.

EACH record of JOIN TABLE still can remember RecID of original table.
 
> Even if there is a aggregate function like
> 
> select name, (count date), sum(points), avg(points) from person, results
> group by name
> 
> there is the same possible relation of each record in the resultset to table
> 3.
> 
> At least i think so.

For this query NO.
Here we CANNOT know ReCID, because each row of result table is RESULT of
calculation from FEW records of original table.

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