exnirad@brolga.cc.uq.oz (Nirad Sharma) (02/28/90)
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.
may@28182.dec.com (Patrick May) (02/28/90)
In article <2310@bunyip.cc.uq.oz>, exnirad@brolga.cc.uq.oz (Nirad Sharma) writes... > > 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 ? If I understand your question correctly, you want to overlay a portion of a screen with another screen, somewhat like "pop-up" windows. The method I have used to do this in SQL*Forms 2.0 involves creating the second screen to look like the first screen with another block overlapping a portion. You would then have to call the second screen from the first. I think that the CRT facility _may_ allow you to specify that only part of the screen should be overwritten when you call a second screen, but that may only work on certain terminal types (or it may have been a hack someone showed me, I haven't worked with Oracle for about six months). You should contact Oracle about SQL*Forms version 3.0 and a product called Application Foundation, if it is feasible for you to upgrade. These products offer functionality to do what you want plus a great deal more. These opinions are mine, I don't work for Oracle, etc., etc., etc. ------------------------------------------------------------------------ "A contract programmer is always intense." may%nmeser.enet@decwrl.dec.com ..!decwrl!nmeser.enet!may