Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!samsung!munnari.oz.au!cluster!metro!bunyip!brolga!exnirad From: exnirad@brolga.cc.uq.oz (Nirad Sharma) Newsgroups: comp.databases Subject: Oracle SQL*FORMS V2.0 overlapping blocks & SQL*ReportWriter QBE Keywords: Oracle,Forms,Reportwriter Message-ID: <2310@bunyip.cc.uq.oz> Date: 28 Feb 90 07:55:05 GMT Sender: news@bunyip.cc.uq.oz Distribution: comp Lines: 25 I am using SQL*FORMS 2.0 and have not found any way in the documentation or my travels through SQL*FORMS to provide overlapping blocks, much like the actual SQL*FORMS development system does. Have I overlooked an area in the documentation or does anyone have any ideas ? My second question concerns the use of the QBE facility as incorporated in SQL*FORMS with SQL*REPORTWRITER reports. It would be nice to allow PRO*C modules to also access the QBE facility. I realise that I could write a PRO*C module that reads the contents of a form when called but surely Oracle allows the passing of the resultant SQL statement to other modules (via user exits ?). The versions of software I am using are : SQL*FORMS 2.0.21 SQL*REPORTWRITR 1.0.11 PRO*C 1.1.10 Any help would be appreciated. Nirad Sharma (exnirad@brolga.cc.uq.oz.au) Continuing Education Unit, The University of Queensland Australia.