I'm not sure how your application is handling dates but if you enter the command:

DAY_FORMAT READ x$

x$ will contain the date format currently in effect.

For this example, the format is "YYYYMMDD" and the dates are stored in the data files this way.

A Query on the invoice file will print Invoice Dates as 20251013, 20240131 etc. if the InvoiceDate$ column is included.

The query definition allows you to press the Add Formula button to define a new column.  I defined it as follows:
Column Title:  Formatted Invoice Date
Formula:  DTE(InvoiceDate$:"%D %Ml, YYYY")
Width: 20


Here is a help link for the Query Formula Definition dialog:
Query Formula Definition

Exactly

Sorry - my previous post should have read 'PxPlus 2023 Update 1'.

Hi again Paula,

While we will investigate updating the NOMADS search you are using to also allow Dependency Logic to be searched, it occurred to me that there is another utility you may want to consider using.  For PxPlus 29023 Update 1, we added new functionality to the Library Bulk Edit and Search Utility to allow searches of NOMADS library files.

The utility you are currently using is only searching specific fields (corresponding to the selected check boxes) in the library files.  This Library Bulk and Search utility searches the entire contents of each record in the library file and displays matching records.  By examining the records it should be possible to determine the exact panel, control and attribute for each match.

For more information:
https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/NOMADS%20Development/Maintaining%20Library%20Objects/Library%20Bulk%20Edit.htm

We have opened a Support Ticket in your name - so you should be notified when we update the ticket.

Hi Paula,

Thanks for bringing this to our attention.

We can duplicate the issue and will create a support ticket for tracking the fix required.

Thanks for the explanation.  Unfortunately, I don't think that there is currently any way to achieve this. 

However, can you tell me if you are using the Data Dictionary and if so - what is the Format for the element that is used for the key? 

Thanks very much for reporting this issue and the solution!  We will ensure the program is updated prior to the next release.

We will also review the code with respect to the performance issues you are seeing using WindX. 

Hi Josh,

Thanks for your question.  Unfortunately the *obj/excel.pvc object does not yet have this functionality.  We will look into adding this for an upcoming release.

It looks like the query definition for the multi-line control is not quite correct.  To use *win/email and *win/url the query for the multi-line control should be defined with Query Type of Query Program rather than Non-Query Logic.


There is documentation about these 'service' queries at:

https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/Dictionary-Based%20Development/Query%20Subsystem/Service%20Queries%20for%20Web,%20Email%20and%20Map.htm

Phil,

The difficulty here is that (I'm assuming) the list or printers needed is variable.  Because of this, the data needed for the drop box needs to be written to a memory file.

I tried the following and it seems to work (although I have not coded a Printer_Validate method).

1) Edited the _fm_panel_iol$ hidden variable in the html file to include printer$
2) Included the following code for the printer drop box:

[row "*\[show usefile field=printer$\]:"][list printer$ size=20 event=Printer_Validate program=c:\webster\prog\tools][/list][/row]<br>

3) Coded the c:\webster\prog/tools program to load a memory file as follows:

! tools - load printer list
!
  ENTER fileno
!
  OPEN (HFN)"*memory*"
  fileno=LFO
!
  printer_list$="Printer A/Printer B/Printer C/"
  FOR val$ FROM printer_list$
  WRITE (fileno,KEY=val$)
  NEXT
!
  EXIT 

You would need to edit your Printer_List method accordingly.

Hope this helps!

Phil,

Just for clarification - you may NOT want to use the File Maintenance Generator method for adding the hidden variable as this would over-write the previous edits you made to the html file.

Hi Phil,

If I'm understanding this correctly - printer$ is the element in the data file being maintained and printerList$ is the delimited list of available printers (that is not an element in the data file).

I have not tried this - but it sounds like you might need to add a Hidden Variable to the form.  You can do this by adding a line using the [hide] short code to the generated html page that looks something like:

[hide printerList$ value=""]

- or -

If you are running PxPlus 2022 or later, you should be able to also do this from within the File Maintenance Generator.  Press the Hidden Variables button on Step 6 and add an Additional Variable of printerList$.

I believe the only difference is that the "OK" button leaves the Copy Screen Objects dialog while the "Apply" button leaves you in the dialog,

We are having some difficulty determining the exact window you are referring to.

Could you perhaps detail the exact steps you follow to display the window or, better yet, attach a screen shot of the the window that is too short?   

Thanks!