We are writing a new app using Oracle as our data source. We have an issue where the selection is behaving different between a screen and a report. We have 2 tables with a master/detail relationship. We are using numeric ids as the primary keys to both tables. A nested report we wrote accessing both tables and using an SQL select works fine. Then for comparison purposes we created a view of the detail table and defined it to PROIV using the id from the master table as the primary key and the id from the detail as secondary. We then changed the report to do a sel-only on the primary key...the report no longer selects any data from the detail table. In order to verify we had everything defined properly we wrote a nested paging screen that accesses the master in the shell and returns the detail in the paging area - a sel-only in this case is working just fine - it returns the desired results. Has anyone else experienced anything like this? Thanks in advance for any help/advice.
We are running version 6.2.35 on Linux and Oracle 10.2.0.5
- ProIV Resource Centre
- → Viewing Profile: Topics: TomWhite
Community Stats
- Group Members
- Active Posts 35
- Profile Views 7,354
- Member Title Member
- Age Age Unknown
- Birthday Birthday Unknown
-
Gender
Not Telling
Previous Fields
-
Year Started ProIV
Not Specified
-
Highest ProIV Version Used
Not Specified
0
Neutral
User Tools
Friends
TomWhite hasn't added any friends yet.
Latest Visitors
Topics I've Started
Oracle Selection Issue
16 December 2011 - 02:43 PM
horizontal scrollbar
16 September 2010 - 09:42 PM
We've had a problem getting horizontal scrollbars on listboxes. They don't seem to work consistently. They show most of the time but sometimes don't - in the same function. It seems like they will always show if the verticle scrollbar is there, with enough records to force the scroll, but if there aren't enough records to force a verticle scrollbar, the horizontal scrollbar does not always show up. We are using version 6.2 on Linux. Has anyone else experienced this, or have any advice on this?
Thanks in advance,
TomWhite
Thanks in advance,
TomWhite
Global Screens
18 November 2009 - 06:38 PM
We are running version 5.5 on Linux and have run into an issue where on globals screens. Boxes don't display if there is a background graphic being used, when we take out the background graphic they display fine or if the screen is not defined as global the box displays fine. Has anyone run into this or does anyone have any ideas on this? Thanks in advance for any ideas/suggestions.
Error Messages
08 May 2009 - 03:23 PM
Can anyone tell me why error messages sometimes display in pop-up windows and sometimes in the screen footer? We have a client that runs a function from the same machine and sometimes the error message shows one way and sometimes the other. We would like to have it always pop-up as it's more obvious there's an error. We are running version 5.5 on Linux. Thanks in advance for any information.
Active X Grid Control
23 March 2009 - 07:20 PM
Can anyone tell me how to load data from a proisam file into an active x grid control supplied with PROIV. We are experimenting with changing some of our paging screens to grids. We use 5.5, but we don't have any of the demo functions that use the controls.
Thanks in advance.
Thanks in advance.
- ProIV Resource Centre
- → Viewing Profile: Topics: TomWhite
- Privacy Policy