WebBrowse with nested JOIN's

[Thomas]

Hello,
my first (simple) web tests are running, so it's time for a real world App ;-)

Is it possible to WebBrowse a more complex View structure as shown below ? The Win32 version I have up and running - that means it works ok from a database point of view.
Any hints are welcome.

TIA, Thomas.

BRW7::View:Browse    VIEW(Auftrag)
                       PROJECT(AUF:AuftragID)
                       PROJECT(AUF:BearbDatum)
                       PROJECT(AUF:Abteilung)
                       PROJECT(AUF:Text)
                       PROJECT(AUF:PatientID)
                       PROJECT(AUF:RPsysID)
                       PROJECT(AUF:ZPsysID)
                         JOIN(RPL:keyRPsysID,AUF:RPsysID)
                           PROJECT(RPL:RPsysID)
                           PROJECT(RPL:RadiologeID)
                          JOIN(RAD:keyRadiologeID,RPL:RadiologeID)
                             PROJECT(RAD:RadiologeID)
                             PROJECT(RAD:Name)
                          END
                       END
                       JOIN(ZPL:keyZPsysID,AUF:ZPsysID)
                          PROJECT(ZPL:ZPsysID)
                          PROJECT(ZPL:ZuweiserID)
                          JOIN(ZUW:keyZuweiserID,ZPL:ZuweiserID)
                            PROJECT(ZUW:ZuweiserID)
                            PROJECT(ZUW:Name)
                         END
                       END
                     END

[Mike Grigsby]

Thomas, I don't do joins quite like that in my Windows apps, but you can simulate it in a couple of ways that I can think of. The obvious one that I use is to make a child browse to the right of the main browse, and filter on the parent record. See the example app where it does this (I think Bruce does it with the Invoice stuff, but maybe it's the mailbox).

The other method would be to build your own values using HTML. This would be quite a bit of work I think, and much more difficult to manage. This would also be difficult to allow child records to be updated. Look for some message threads and examples on this forum from John about XHTML in browses.

[Thomas]

hmmm.. a simple one to many parent-child relation is no prob at all. I would like to hear from you Pros that such a Browse is possible before starting the project.

Thank you Mike, will search the forum.

[Bruce]

Hi Thomas,

As far as coding the View goes - any legal view structure can be done. there's an embed point _inside_ the view itself, so you can basically hand-code anything into the view that you like.

Cheers
Bruce

[Thomas]

yeah... meanwhile I found your Accounts example wich helps a lot.
thnx again, Thomas.