Query - Vieuw



When I run the code below, which I received from you, this program runs in a loop. It doesn't stop.


delete (select qry_Contractor);

for a in select Contractor do

for b in select Gebruiker do

for c in select Registraties_Detail do

let z := (create qry_Contractor);

z.(Contractor := a.Contractor);

z.(Gebruiker := b.Naam);

z.(Reference := c.Referentie);

z.(Registratie := c.Issue);

z.(Tag := c.TAG);

z.(Aantal := c.Aantal);

z.(Bonnummer := c.Bonnr)








2 replies

    • John_Halls
    • 1 yr ago
    • Reported - view

    Hi Michel


    How many records do you have in each of the tables Contractor, Gebruiker and Registraties_Detail?


    Regards John

    • Sean
    • 1 yr ago
    • Reported - view

    I apologize, I haven't use Paul's code and it's clear after rereading the thread that he doesn't explicitly state several steps that I implicitly understood.


    1) The code goes into a Button not a View layout element.

    2) You need to create a Table (you can name it qry_Contractor) to receive the results. This table needs to have the fields "Contractor", "Gebruiker", etc. defined in it.

    3) In the View formula enter: select qry_Contractor


    You will need to click the button anytime you want to update the results of the "query" view.

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 149Views