Detail of relationship add

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
Post Reply
Pablo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 190
Joined: Fri, 27 Oct 2006 11:12 am
Location: 88350000
Pablo

Good morning gentlemen.

I have Forms 6i ... when I create 2 blocks, Master and Detail. The Detail has 5 lines ... Well, it is occurring, when I consult in the Master block, all right, shows the information of the 2 blocks, however, when I click on the Detail block (on any line other than 1 °), ,, add all information. I have to enter with the query again (F7, F8) to show the information.
.. If you query and click on the 1st line of Detail, then the records remain with I can navigate normally through the fields.
I have already made several changes in the relationships but I have no idea what parameter to move.

Thanks
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

Good afternoon Pablo.

See if in these relationship changes you did not get unnecessary triggers in the blocks.

My blocks are equal to the annex.
Attachments
tela de relacionamento
tela de relacionamento
Pablo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 190
Joined: Fri, 27 Oct 2006 11:12 am
Location: 88350000
Pablo

Hello Spernega.

Yes, it is equal to its Annex.
As the trigger, the trigger is created (automatically) and ON-CHECK-DELETE-MASTER all 2 trigger, I made changes (commenting on the codes) and even then gives the problem.
What I noticed was that if creating a Detail of 3 related tables happens the problem.

For example:
CAD_TRANSPORTADORA (has 1 record)
| CAD_PESOS_ATENDIDOS_TRANSP (has 5 records)
| CAD_TAXAS_TRANSPORTADORA_POR_PESO (has 5 registration line)


then, in the creation of the detail of the last table, begins to "pipocar" the last 2 blocks.
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

Pablo,

This has all the even dirt pint.

Want to send the forms to take a look?

Who knows something draws attention.
Pablo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 190
Joined: Fri, 27 Oct 2006 11:12 am
Location: 88350000
Pablo

Pinta de dirt is good ... kkkkk ...

beleza, is attached

Thanks
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

Good morning Pablo,

I could not access the Annex.
Pablo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 190
Joined: Fri, 27 Oct 2006 11:12 am
Location: 88350000
Pablo

I'll try again ... if you do not give, send me an email (ti@vinculobasic.com.br) that I send you the file. If we can solve it here, what was the "magic" ;; rsrsrs
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

Closed, I'm sending.
Pablo
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 190
Joined: Fri, 27 Oct 2006 11:12 am
Location: 88350000
Pablo

Hello people.
The great friend Spernega found the problem. What happened is that the relation name was equal to the name of the block, renaming the relation the problem solves.

Big hug to all.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 16 guests