Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
76
Programming / Re: File maintenance panel creation for flat files,
« on: July 25, 2018, 02:57:52 PM »
When defining key for your file, click on the Define Keys button, which will invoke the Key Definition interface. Click New Key to add your primary key.
The Primary Key Definition interface will list the Data Fields for the file in a list box at the left. Add the fields that make up the key to the Key Segments list box by double clicking on the field name, or by highlighting it and clicking the Ascending or Descending button(depending on the desired sort order) to add it to segments. You can specify substrings and segment options by highlighting the key segment and clicking on the appropriate button. When all the key segments have been chosen, you can optionally give the the key a Key Name, and press OK to save the definition.
The Key Definition panel will now show the key definition. You can then add alternate keys for your file in a similar way.
This is documented at:
https://manual.pvxplus.com/page/Data%20Dictionary/Data%20Dictionary%20Maintenance/Defining%20Keys.htm
The Primary Key Definition interface will list the Data Fields for the file in a list box at the left. Add the fields that make up the key to the Key Segments list box by double clicking on the field name, or by highlighting it and clicking the Ascending or Descending button(depending on the desired sort order) to add it to segments. You can specify substrings and segment options by highlighting the key segment and clicking on the appropriate button. When all the key segments have been chosen, you can optionally give the the key a Key Name, and press OK to save the definition.
The Key Definition panel will now show the key definition. You can then add alternate keys for your file in a similar way.
This is documented at:
https://manual.pvxplus.com/page/Data%20Dictionary/Data%20Dictionary%20Maintenance/Defining%20Keys.htm
77
Programming / Re: File maintenance panel creation for flat files,
« on: July 25, 2018, 09:01:11 AM »
File definitions in the data dictionary consist of field definitions and key definitions. It looks like you have not defined any key(s) for your file. If you load the file definition in Data Dictionary Maintenance, there is a Define Keys button on the toolbar that will allow you to specify the key(s) by which you can read the file. When you have finished defining keys, be sure to click the Update File button to add the new info into the file.
78
Nomads / Re: New Query not pre-loading
« on: July 12, 2018, 08:52:31 AM »
It does not make sense to display a 'Loading' message when load-on-demand is being used, as pages are only loaded when needed. A message is displayed, however, when you click on a column to sort and all the records have not yet been loaded. I'm just not sure what version that occurs in.
79
Nomads / Re: New Query not pre-loading
« on: July 10, 2018, 03:29:34 PM »
The new query does not actually pre-load data. This is an option setting for the classic query to allow column sorting. The new query will either load-on-demand or background load. The issue which you may be encountering is that you can only sort on a column when all the data has been loaded into the query listbox. With the classic query, there was no display until all the records were read, so when you clicked on the column header, the sort occurred. With the new query, records are displayed before they have all been read, so there could be a wait while records are being loaded before the sort could happen.
80
Nomads / Re: Data Read logic in nomads DD or View definition
« on: July 10, 2018, 08:53:29 AM »
When you define a Data Source for a View, on the Elements tab you can add your own element and include a PxPlus expression in the Expression column to build the value you want.