Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 12 OCT 2006 12:39:34PM Joe Tursone wrote:

I am looking to Construct a Comparison based on a specific field. I do not know which table to find the field and am not sure of the field name. I do know that the field is labeled "Action Code" in the Summary Reporting Form and Assessment Certification data input screen.


At 13 OCT 2006 06:12AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Joe

AREV is a database development environment used by a multitude of companies to develop vertical market software. You are obviously using such a package so without knowing which package you are referrring to it will be difficult to help.

Sometimes developers add a feature to their applications which allows you to press an "Alt" key when on a prompt which will show the dictionary name of the current prompt. If you press Alt-M in the screen do you see a screen showing actions for Alt 1-5 - and if so do any of them look as though they do what you need?

The Sprezzatura Group

World leaders in all things RevSoft


At 16 OCT 2006 09:34AM Steve Smith wrote:

Make a copy of your system and work with this (not the live system).

Enter the system.

Hit F5 to bring up TCL, then enter the following commands:

SELECT WINDOWS WITH DATA 'Action Code'

EDIT WINDOWS

Hit Alt-F to present each record in turn.

Hit Ctrl-F to search for the prompt "Action Code" - next to it will possibly be a field name you can use in your report.

If you page down towards the bottom you can see the file name (if any) associated with the screen - usually on a line with "squiggly equals signs" on it.

Once you have the field name and file name you can see if you can run a report. You may find the field is dynamically created, or else the window is not anchored to a file (it's a collector) or the data may not have a dictionary associated with it. All these factors can bring this approach undone.

But it is worth a shot.

View this thread on the forum...

  • third_party_content/community/commentary/forums_nonworks/c0861192e123968585257205005b839d.txt
  • Last modified: 2023/12/28 07:39
  • by 127.0.0.1