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!

Not sure if this will help - but in PxPlus 2017 we added a PxPlus Word Object to simplify interactions with Word.  It may make translating your existing code easier.

You should be able to see the documentation for this object at the link below:

https://manual.pvxplus.com/PXPLUS/PxPlus%20User%20Guide/External%20Components/PxPlus%20COM%20Support/Word%20Object.htm

Tom,

The PxPlus Excel object will look for Excel locally on the machine that instantiates the object (X_OBJ=new(*obj/excel).  If you run the program on a workstation, that workstation will need to have Excel installed.  If the program is run on the server - only the server should need to have Excel installed.  However, the excel file created would also be on the server.

There may be ways around this if you do not use the PxPlus Excel Object.

Tom,

It appears that writing the data using WindX may be the issue.  Please open a support ticket and be sure to provide the version and serial number.

Tom,

You can print TCB(29) to see what version is installed.  Version 16 should show 16000000 and 16.2 should show 16200000.

Just to clarify - were you still using WindX when it worked using verison 20?

Thanks,

Hi Tom,

I have had some co-workers try your program as well.  It worked fine in all cases.

It might also be a problem with the SEP separator.  The current separator can be checked by printing X_OBJ'SEP$ after instantiating the X_OBJ object.

Setting X_OBJ'VISIBLE = 1 shows the Excel application and might help to see what it looks like immediately after the WRITE function is completed.

Version 16 is no longer supported.  If the issue is still unresolved, you could download a newer version and retry your program using a demo activation.  Assuming the issue still occurs, you could then open a support ticket.  We would be interested in screen shots of the program as well as the results in excel etc.

Hi Tom,

I tried this with our current version and with PxPlus 2019 (version 16) of the excel object and it works fine for me.

When the workbook is created - it will use the excel default template.  Is it possible this has some sort of formatting already there for these cells?