Re: Developper 2000 master/detail

From: Curtis <cmarchand_at_norambar.ca>
Date: 14 May 2004 05:45:55 -0700
Message-ID: <77459c6d.0405140445.34e07b74_at_posting.google.com>


> Did You create the 2 blocks with the Data Block Wizard (well, I do not
> recall if it was available in 4.5) ?
> At least from 5 and higher on, the Wizard did the things fro You, and the
> only thing to check for
> is the proper mapping of the relationship of the database to the blocks. One
> may be unhappy
> with wizards, but they are always the best first step to my view.
>
> Maybe You could show us the tables, the FK and also and some example data
> from the database,
> using Sql*plus ? In the end, it could also be the data ...
>
> Jan:)

[Quoted] Here are both tables

Table1_Name = Parametres_Cisailleur

 Name                            Null?    Type
 ------------------------------- -------- ----
 CYCLE                                    VARCHAR2(3)
 ITEM                                     NUMBER(5,1)
 VITESSE_DEMELEUR                         NUMBER(4)
 SAUT_REGULIER                            NUMBER(2)
 SAUT_SPECIAUX                            NUMBER(2)
 NB_PAQUET_ENTRE_SAUT_SPECIAUX            NUMBER(2)
 SAUT_ACTUEL                              NUMBER(2)

Table2_Name = Commande
 Name                            Null?    Type
 ------------------------------- -------- ----
 CYCLE                                    VARCHAR2(3)
 ITEM                                     NUMBER(5,1)
 DIMLAM                                   VARCHAR2(11)

Here are the steps I did to create the form

1- Tools --> New block 
2- base table --> Parametres_Cisailleur
3- Select all rows from Parametres_Cisailleur
4- click OK button
5- tools --> New block
6- base tabel --> commande
7- select all rows from commande
8- go to master/detail page
9- master block --> Parametres_Cisailleur
10- join condition =
Parametres_Cisailleur.item = commande.item and Parametres_Cisailleur.cycle = comande.cycle 11- click ok button
12- I set block1 and block2 properties --> records displayed 10

When I run form, I press F7 then F8 to execute query. I get block1 "Parametres_Cisailleur" populated with all records from table and block2 "Commande" is only populated for line 1 of block1 "Parametres_Cisailleur". If I scroll down in records, only line 1 of block2 "Commande" changes. What should hapen is that where there's a record for block1 a value from block2 should be at same row.

P.S. There's a corresponding record in table commande for each record in table Parametres_Cisailleur. The relation between the two tables is cycle and item.

Thanks!
Curtis Received on Fri May 14 2004 - 14:45:55 CEST

Original text of this message